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

by Matt Allington

Overview

Data analysis expressions (DAX) is the formula language of Power BI. Learning the DAX language is key to empower Power BI users so they can take advantage of these new Business Intelligence (BI) capabilities. This third edition has been updated for the new Power BI Ribbon interface while still providing a bridge for readers wanting to learn DAX in the Power BI, Power Pivot, or Excel.

Product Details

ISBN-13:	9781615470693
Publisher:	Holy Macro! Books
Publication date:	04/01/2021
Edition description:	Third edition
Pages:	280
Sales rank:	221,824
Product dimensions:	8.25(w) x 10.75(h) x 0.60(d)

About the Author

Matt Allington is an Microsoft Data Platform MVP that specialises in teaching and helping business users leverage the Power BI suite of tools to achieve positive business outcomes. Matt has a unique work experience history having spent 15 years working in commercial roles using data, and 10 years working in IT roles supporting business users to get the data they need. It is the combination of this work history and Matt's rare skill and ability to clearly explain technical concepts that make this book such a valuable stand-alone learning resource.

Table of Contents

Introduction iv

1 Concept: Introduction to Data Modelling 6

2 Concept: Loading Data 8

3 Concept: Measures 29

4 DAX Topic: SUMO, COUNTQ, 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 AVE RAG EX () 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(), HASONEVALUEQ, SELECTEDVALUE(), and CONCATENATEX() 103

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

15 DAX Topic: FILTERQ 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

Index 279