Analytics with Power BI Desktop
Lab 1 - Transforming Data with Power Query
Get Data
Use the Power Query Editor
Renaming Tables
Merging Queries
Creating Custom Columns
Splitting Data into Multiple Columns
Column from Examples
Lab 2 - Creating Relationships
Switch to Data Modelling Pane
Arrange the Tables
Creating Relationships
Lab 3 - Creating Calculated Columns & Measures
Creating & Formatting Calculated Columns
Additive Calculated Columns
Non-additive Calculated Columns
Creating & Formatting Measures
Measure - Count of Orders
Measure - Sum of Sales Including Tax
Try Creating a Measure for Sum of Sales
Solution 1
Enabling Time Intelligence
Using Time Intelligence in DAX
Calculating Total Sales Last Month
Calculating the Variance between Months
Try Creating a Measure
Solution - Total Sales Monthly Variance
Calculating the variance percentage on last month
Lab 4 - Configuring Common Charts & Filters
Slicer Visual
Time Series
Bar Chart
Analytics with Power BI Hands-On Labs
>
Lab 3 - Creating Calculated Columns & Measures
>
Creating & Formatting Measures
> Measure - Sum of Sales Including Tax
Measure - Sum of Sales Including Tax
DAX syntax for summing a column is:
Measure Name = SUM(‘TableName’[Column Name])