Supercharge Excel

Table of Contents

1. Concept: Introduction to Data Modelling
2. Concept: Loading Data
3. Concept: Measures
4. DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE()
5. Concept: Filter Propagation
6. Concept: Lookup Tables and Data Tables
7. DAX Topic: The Basic Iterators SUMX() and AVERAGEX()
8. DAX Topic: Calculated Columns
9. DAX Topic: CALCULATE()
10. Concept: Evaluation Context and Context Transition
11. DAX Topic: IF(), SWITCH(), and FIND()
12. DAX Topic: VALUES() and HASONEVALUE()
13. DAX Topic: ALL(), ALLEXCEPT(), and ALLSELECTED()
14. DAX Topic: FILTER()
15. DAX Topic: Time Intelligence
16. DAX Topic: RELATED() and RELATEDTABLE()
17. Concept: Disconnected Tables
18. Concept: KPIs
19. Concept: Multiple Data Tables
20. Concept: Cube Formulas
21. Moving from Excel to Power BI
22. Next Steps on Your DAX Journey