Excellent starting point. Since you already know Excel and Power BI, I won't teach DAX like a beginner learning spreadsheets. Instead, I'll teach it the way a Data Analyst needs to understand it for reporting, dashboards, KPIs, business analysis, and interviews.
We'll learn DAX in this order:
- What DAX is
- Calculated Columns vs Measures
- Aggregation Functions
- Filter Context
- Row Context
- Context Transition
- Variables (VAR)
- CALCULATE()
- FILTER()
- ALL(), ALLEXCEPT(), REMOVEFILTERS()
- DIVIDE()
- DISTINCTCOUNT()
- SELECTEDVALUE()
- SWITCH()
- Date Tables
- YTD
- MTD
- QTD
- Previous Period Analysis
- YoY Growth
- Running Totals
- Ranking
- Dynamic Measures
- Virtual Tables
- Iterator Functions
- Performance Optimization
- Sales Dashboard
- HR Dashboard
- Financial Dashboard
- Interview Questions