Supercharge Power BI - 3rd Edition

  • 4h 16m
  • Matt Allington
  • Tickling Keys
  • 2021

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.

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.

In this Book

  • Concept: Introduction to Data Modelling
  • Concept: Loading Data
  • Concept: Measures
  • DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE()
  • Concept: Filter Propagation
  • Concept: Lookup Tables and Data Tables
  • DAX Topic: Calculated Columns
  • DAX Topic: The Basic Iterators SUMX() and AVERAGEX()
  • DAX Topic: CALCULATE()
  • DAX Topic: Making DAX Easy to Read
  • Concept: Evaluation Context and Context Transition
  • DAX Topic: IF(), SWITCH(), and FIND()
  • DAX Topic: VALUES(), HASONEVALUE(), SELECTEDVALUE(), and CONCATENATEX()
  • DAX Topic: ALL(), REMOVEFILTERS(), ALLEXCEPT(), and ALLSELECTED()
  • DAX Topic: FILTER()
  • DAX Topic: Time Intelligence
  • DAX Topic: Variables in DAX
  • DAX Topic: RANKX() and TOPN()
  • DAX Topic: RELATED() and RELATEDTABLE()
  • Concept: Disconnected Tables
  • Concept: Multiple Data Tables
  • Concept: Using Analyze in Excel and Cube Formulas
  • Concept: Transferring DAX Skills to Excel
  • Concept: Next Steps on Your DAX Journey
SHOW MORE
FREE ACCESS