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
> Using Time Intelligence in DAX
Now that we’ve enabled Time Intelligence in the previous step, we can use Time Intelligence formulas in DAX.
Using Time Intelligence in DAX
Now that we’ve enabled Time Intelligence in the previous step, we can use Time Intelligence formulas in DAX.