Course Content
-
1. Introduction
-
2. How the Power BI Platform Works
-
3. Working with Data
-
4. Query Editor
-
5. DAX Language
-
6. Introduction to DAX Formulas
- Creating a separate table for measures
- Creating a table using GENERATESERIES formula
- Leveraging the POWER function
- Leveraging the DIVIDE function
- Introducing parameter-harvesting functions
- Introducing the X-factor functions
- Utilizing the X factor (SUMX, COUNTX, etc.) for ranges
- Utilizing quick measures
-
7. Advanced DAX Calculations
- Creating a date table using a formula
- Filtering between tables
- Utilizing IF statements with conditional functions
- Creating dynamic measures
- Introducing the DATEDIFF measure
- Working with disconnected tables
- Leveraging the BLANK function
- Using variables in formulas
- DATESBETWEEN and the X functions
- Introducing the DATEADD date calculations
- Introducing the MTD, QTD, and YTD date calculations
-
8. Graphing and Dashboard Design
This content is protected, please login and enroll course to view this content!