iii
Table of Contents
Introducon ....................................................................................................................................... iv
1: Concept: Introducon 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 Propagaon ...........................................................................................................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: Evaluaon Context and Context Transion ....................................................................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: Mulple 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 Pracce Exercises ......................................................................................193
Table of Here's How Secons...........................................................................................................202
Index ...............................................................................................................................................203
