Lesson 1: Basic DAX Functionality
- Review of Calculated Columns
- Review of Measures
- Rules of Evaluation
- Evaluation Context
- Quick Measures
Lesson 2: Controlling Content & Values
- Controlling Values
- Error Handling
Lesson 3: Content Control Functions
- Iterative Functions
- The FILTER Function
- The ALL Function
- The CALCULATE Function
- Additional All Functions
Lesson 4: Contexts In Relationships
- Working With Many Tables
- Row Context & Relationships
- Elevated Calculated Columns
- Filter Context & Relationships
- Cross Filtering Issues
Lesson 5: Time Intelligence Functions
- Calculating Operating Periods
- To-Date Functions
- Controlling Totals
- Advanced Date Functions
- Prior Year Functions