1: Concept: Introduction to Data Modelling..........................................................................................1
2: Concept: Loading Data.....................................................................................................................3
3: Concept: Measures.........................................................................................................................25
4: DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE().............34
5: Concept: Filter Propagation............................................................................................................51
6: Concept: Lookup Tables and Data Tables........................................................................................57
7: DAX Topic: The Basic Iterators SUMX() and AVERAGEX().................................................................62
8: DAX Topic: Calculated Columns......................................................................................................71
9: DAX Topic: CALCULATE().................................................................................................................74
10: Concept: Evaluation Context and Context Transition.....................................................................82
11: DAX Topic: IF(), SWITCH(), and FIND()...........................................................................................88
12: DAX Topic: VALUES() and HASONEVALUE()....................................................................................91
13: DAX Topic: ALL(), ALLEXCEPT(), and ALLSELECTED().......................................................................98
14: DAX Topic: FILTER().....................................................................................................................111
15: DAX Topic: Time Intelligence.......................................................................................................120
16: DAX Topic: RELATED() and RELATEDTABLE().................................................................................144
17: Concept: Disconnected Tables....................................................................................................149
18: Concept: KPIs.............................................................................................................................164
19: Concept: Multiple Data Tables....................................................................................................167
20: Concept: Cube Formulas.............................................................................................................175
21: Moving from Excel to Power BI...................................................................................................181
22: Next Steps on Your DAX Journey.................................................................................................191
Appendix A: Answers to Practice Exercises.......................................................................................193
Table of Here's How Sections...........................................................................................................202