Supercharge Power BI - 3rd Edition


February 2021

Supercharge Power BI - 3rd Edition

Hands-on book to learn and master the DAX language!

Bill Jelen, MrExcel

category: Power BI
covers: Office 365

Product Details
  • 280 Pages
  • Publisher: Holy Macro! Books
  • ISBN: 978-1-61547-069-3
  • PDF ISBN: 978-1-61547-155-3

Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas. Microsoft Power BI is a self-service business intelligence tool. Anyone can get started with Power BI by downloading Power BI Desktop, loading up some data, and building a report. But with this basic approach, you can only scratch the surface of POWER BI's capabilities. If you want to be able to supercharge Power BI, you need to learn to write DAX. Data Analysis Expressions (DAX) is the formula language of Power BI and Power Pivot for Excel.

This book prompts the reader to put your new skills to the test. Written to give you hands-on practice using Power BI Desktop and writing DAX.

  1. Introduction
  2. Concept: Introduction to Data Modelling
  3. Concept: Loading Data
  4. Concept: Measures
  5. DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE()
  6. Concept: Filter Propagation
  7. Concept: Lookup Tables and Data Tables
  8. DAX Topic: Calculated Columns
  9. DAX Topic: The Basic Iterators SUMX() and AVERAGEX()
  10. DAX Topic: CALCULATE()
  11. DAX Topic: Making DAX Easy to Read
  12. Concept: Evaluation Context and Context Transition
  13. DAX Topic: IF(), SWITCH(), and FIND()
  14. DAX Topic: VALUES(), HASONEVALUE(), SELECTEDVALUE(), and CONCATENATEX()
  15. DAX Topic: ALL(), REMOVEFILTERS(), ALLEXCEPT(), and ALLSELECTED()
  16. DAX Topic: FILTER()
  17. DAX Topic: Time Intelligence
  18. DAX Topic: Variables in DAX
  19. DAX Topic: RANKX() and TOPN()
  20. DAX Topic: RELATED() and RELATEDTABLE()
  21. Concept: Disconnected Tables
  22. Concept: Multiple Data Tables
  23. Concept: Using Analyze in Excel and Cube Formulas
  24. Concept: Transferring DAX Skills to Excel
  25. Concept: Next Steps on Your DAX Journey
  26. Appendix A: Answers to Practice Exercises
  27. Appendix B - DAX Quick Reference List

Where to Buy

MrExcel Bookstore

eBook from MrExcel.

MrExcel Bookstore

Print book from MrExcel (April 2021)


Other Editions


Learn to Write DAX

December 2015

Data analysis expressions (DAX) is the formula language of PowerPivot and Power BI. Simply reading a book is normally not enough to help Excel users learn DAX skills – you need to complete exercises and get plenty of practice to make the transition.


Supercharge Power BI

February 2018

If you want to be able to supercharge Power BI, you need to learn to write DAX. Data Analysis Expressions (DAX) is the formula language of Power BI and Power Pivot for Excel. This book prompts the reader to put your new skills to the test. Written to give you hands-on practice using Power BI Desktop and writing DAX.


Related Products


Master Your Data with Power Query in Excel and Power BI

August 2021

Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.