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

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 volume clearly explains the concepts of DAX while at the same time offering hands-on practice to engage the reader and help new knowledge stick. 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. Updated for new Power BI User Interface.

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 also having spent 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. 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.

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