Supercharge Power BI Power BI is Better When You Learn To Write DAX

1: Concept: Introduction to Data Modelling..........................................................................................6

2: Concept: Loading Data.....................................................................................................................8

3: Concept: Measures.........................................................................................................................29

4: DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE().............41

5: Concept: Filter Propagation............................................................................................................59

6: Concept: Lookup Tables and Data Tables........................................................................................64

7: DAX Topic: Calculated Columns......................................................................................................69

8: DAX Topic: The Basic Iterators SUMX() and AVERAGEX().................................................................75

9: DAX Topic: CALCULATE().................................................................................................................85

10: DAX Topic: Making DAX Easy to Read............................................................................................90

11: Concept: Evaluation Context and Context Transition.....................................................................92

12: DAX Topic: IF(), SWITCH(), and FIND().........................................................................................100

13: DAX Topic: VALUES(), HASONEVALUE(), SELECTEDVALUE(), and CONCATENATEX().......................103

14: DAX Topic: ALL(), REMOVEFILTERS(), ALLEXCEPT(), and ALLSELECTED()........................................115

15: DAX Topic: FILTER().....................................................................................................................131

16: DAX Topic: Time Intelligence.......................................................................................................144

17: DAX Topic: Variables in DAX........................................................................................................176

18: DAX Topic: RANKX() and TOPN().................................................................................................179

19: DAX Topic: RELATED() and RELATEDTABLE().................................................................................187

20: Concept: Disconnected Tables....................................................................................................192

21: Concept: Multiple Data Tables....................................................................................................211

22: Concept: Using Analyze in Excel and Cube Formulas...................................................................226

23: Concept: Transferring DAX Skills to Excel....................................................................................239

24: Concept: Next Steps on Your DAX Journey..................................................................................249

Appendix A: Answers to Practice Exercises.......................................................................................252

Appendix B - DAX Quick Reference List.............................................................................................260

Table of Here's How Sections...........................................................................................................278