Module 1: Introduction to DAX

Module 2: Table Functions

Module 3: Evaluation Contexts

Module 4: CALCULATE Function

Module 5: Iterators

Module 6: Time Intelligence in DAX

Module 7: Hierarchies in DAX

Module 8: ALLSELECTED and Shadow Filter Contexts

Module 9: Segmentation

Module 10: Many-to-many Relationships

LAB Exercises:

Lab 02
- Percentage of sales
- Delivery working days
- Sales of products in the first week
- Customers with children

Lab 03
- Nested iterators
- Customers in North America (BASIC)
- Create a parameter table

Lab 06
- Ranking customers (static)
- Ranking customers (dynamic)
- Date with the highest sales
- Moving average

Lab 07
- Running total
- Comparison YOY%
- Sales in the first three months
- Semi-additive calculations

Module 11: Introduction to Data Modeling

Module 12: Header / Detail Tables

Module 13: Working with Date and Time

Module 14: Using Snapshot Tables

Module 15: Analyzing Date and Time Intervals

Module 16: Many-to-Many Relationships

Module 17: Working with Different Granularities

GRC-112: Microsoft Power BI Data Modeling with DAX