MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Supercharge Power BI


February 2018

Supercharge Power BI

Power BI is Better When You Learn to Write DAX!

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

Bill Jelen, MrExcel

category: Power BI
covers: Office 365

Product Details
  • Paperback: 192 Pages
  • Publisher: Holy Macro! Books
  • Print ISBN: 978-1-61547-054-9
  • PDF ISBN: 978-1-61547-237-6
  • ePub ISBN: 978-1-61547-360-1
  • Mobi (Kindle) ISBN: 978-1-61547-137-9

Released in 2018, 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: The Basic Iterators SUMX() and AVERAGEX()
  9. DAX Topic: Calculated Columns
  10. DAX Topic: CALCULATE()
  11. Concept: Evaluation Context and Context Transition
  12. DAX Topic: IF(), SWITCH(), and FIND()
  13. DAX Topic: VALUES(), HASONEVALUE(), SELECTEDVALUE(), and CONCATENATEX()
  14. DAX Topic: ALL(), ALLEXCEPT(), and ALLSELECTED()
  15. DAX Topic: FILTER()
  16. DAX Topic: Time Intelligence
  17. DAX Topic: RELATED() and RELATEDTABLE()
  18. Concept: Disconnected Tables
  19. Concept: Multiple Data Tables
  20. Concept: Using Analyze in Excel and Cube Formulas
  21. Transferring Your Skills to Excel
  22. Next Steps on Your DAX Journey
  23. Appendix A: Answers to Practice Exercises
  24. Table of Here's How Sections
  25. Index

Where to Buy

MrExcel Store

We will ship you a physical copy of the book, plus you can immediately download the e-book in any of three DRM-Free versions: PDF, ePub, or Mobi.

Print Book from MrExcel »

MrExcel Store

Outside of the USA, purchase the e-book. Again, you can choose from any of 3 DRM-Free editions when you purchase from:

e-Book from MrExcel »

Other Editions

Related Products