Mohamad Mahmoodhashnotes.hashnode.dev·Sep 17, 2024Power BI Practice: Using DAX USERELATIONSHIP for Multiple Date KeysScenario: You have a Power Bl report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys: 1. Due Date 2. Order Date 3. Delivery Date You need to support the analysis ...PowerBI
Mohamad Mahmoodhashnotes.hashnode.dev·Sep 17, 2024Power BI Practice: Concatenation generally does not improve dataset performanceScenario: Given meta data: column_name, data_example, valid_profile IoT GUID, 48196321-3809-EC11-883D-0022489A2..., 100% IoT DateTime, 21/05/2022 18:59:25, 100% IoT ID, 10000010000, 100% The IOT ID columns are unique to each row in query. You nee...PowerBI
Mohamad Mahmoodhashnotes.hashnode.dev·Sep 17, 2024Power BI Practice: Average Line vs Median Line in Power BI VisualizationScenario: You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars. You need to create a reference line to show ...PowerBI
Mohamad Mahmoodhashnotes.hashnode.dev·Sep 17, 2024Power BI Practice: Optimize Power BI Datasets, Remove Irrelevant FieldsScenario: Given meta data: column_name, data_example, valid_profile IoT GUID, 48196321-3809-EC11-883D-0022489A2..., 100% IoT DateTime, 21/05/2022 18:59:25, 100% IoT ID, 10000010000, 100% The IoT GUID and IoT ID columns are unique to each row in q...Power BI
Mohamad Mahmoodhashnotes.hashnode.dev·Sep 17, 2024Power BI Practice: Counting Orders by Different Dates in Power BI Using CALCULATE and USERELATIONSHIPScenario: You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date. The tables have the following relationships: Sales...PowerBI
Mohamad Mahmoodhashnotes.hashnode.dev·Sep 17, 2024Power BI Practice: Filter Step is Not Efficient for Importing Data in Power BI, Use SQL WHERE Clauses InsteadScenario: You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from...PowerBI
Mohamad Mahmoodhashnotes.hashnode.dev·Sep 17, 2024Power BI Practice: Why 'Connect' Isn't Enough: Properly Recreate Power View Sheets in Power BIScenario: You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets. You need to recreate the Power View sheets as reports in the Power Bl service. Solution: From the Power Bl se...PowerBI
Mohamad Mahmoodhashnotes.hashnode.dev·Sep 17, 2024Power BI Practice: Avoid DateTime Data Loss During Data TransformationScenario: Given meta data: column_name, data_example, valid_profile IoT GUID, 48196321-3809-EC11-883D-0022489A2..., 100% IoT DateTime, 21/05/2022 18:59:25, 100% IoT ID, 10000010000, 100% The IOT ID columns are unique to each row in query. You nee...PowerBI
Mohamad Mahmoodhashnotes.hashnode.dev·Sep 17, 2024Power BI Practice: Report-Level Filters Are Ineffective for Sampling Data in Power BIScenario: You are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from...PowerBI
Mohamad Mahmoodhashnotes.hashnode.dev·Sep 17, 2024Power BI Practice: Centralizing Excel Data Source References in Power BI Using Power Query MScenario: You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source. You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each q...Power BI