Learning Objectives
- Use time intelligence functions to compare periods and trends
- Build a running total measure
- Use variables (VAR/RETURN) to simplify complex DAX
- Rank doctors or branches using RANKX
Key Topics Covered
- SAMEPERIODLASTYEAR and DATESYTD
- Running totals with CALCULATE and filter functions
- VAR/RETURN for readable DAX
- ALL and ALLEXCEPT
- RANKX for leaderboards