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: Calculated Columns
8. DAX Topic: The Basic Iterators SUMX() and AVERAGEX()
9. DAX Topic: CALCULATE()
10. DAX Topic: Making DAX Easy to Read
11. Concept: Evaluation Context and Context Transition
12. DAX Topic: IF(), SWITCH(), and FIND()
13. DAX Topic: VALUES(), HASONEVALUE(), SELECTEDVALUE(), and CONCATENATEX()
14. DAX Topic: ALL(), REMOVEFILTERS(), ALLEXCEPT(), and ALLSELECTED()
15. DAX Topic: FILTER()
16. DAX Topic: Time Intelligence
17. DAX Topic: Variables in DAX
18. DAX Topic: RANKX() and TOPN()
19. DAX Topic: RELATED() and RELATEDTABLE()
20. Concept: Disconnected Tables
21. Concept: Multiple Data Tables
22. Concept: Using Analyze in Excel and Cube Formulas
23. Concept: Transferring DAX Skills to Excel
24. Concept: Next Steps on Your DAX Journey