DAX intermediate path
Master filter context, CALCULATE and the patterns analysts use every week.
Build confidence with the DAX course and then apply it: ranking, shares of total and rolling averages on realistic sample data.
What you will be able to do
- Explain filter context and use CALCULATE correctly
- Build ranking, Top N and percent-of-total measures
- Create rolling averages and period comparisons
- Spot and fix common DAX mistakes
Before you start
- Comfortable with Power BI Desktop basics
- Know what a measure and a relationship are
The path, step by step
- DAX Fundamentals - The core DAX course
- Contribution % of total - Shares that respect slicers
- Rank by sales - Ranking with RANKX
- Top N products - Show only the Top N
- Rolling 3-month average - Smooth a monthly trend
- Mobile Subscribers and Churn (synthetic) - Practise churn analysis with these measures