MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Supercharge Excel When You Learn to Write DAX For Power Pivot


April 2018

Supercharge Excel When You Learn to Write DAX For Power Pivot

Power Pivot is Better When You Learn to Write DAX!

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

Bill Jelen, MrExcel

category: Power Pivot
covers: Office 365

Product Details
  • 224 Pages
  • Publisher: Holy Macro! Books
  • ISBN: 978-1-61547-053-2
  • PDF ISBN: 978-1-61547-236-9
  • ePub ISBN: 978-1-61547-359-5
  • Mobi (Kindle) ISBN: 978-1-61547-136-2

Power Pivot is a self-service business intelligence tool that comes bundled with Microsoft Excel. Anyone can get started with Power Pivot by enabling the add-in, loading some data, and building a pivot table. But that basic approach allows you to only scratch the surface of Power Pivot’s capabilities. If you want to be able to supercharge Excel using Power Pivot, you need to learn to write DAX, the formula language of Power Pivot for Excel and Power BI. With the help of a good book that prompts readers to put their new skills to the test, Excel users can rather quickly learn the required DAX skills. This is such a book, written to give you hands-on practice using Power Pivot for Excel and writing DAX. Inside you will find explanations of concepts, examples, worked-though exercises, and practice exercises and answers to maximise learning retention and experience.

Supercharge Power BI

This is a sister book to Supercharge Power BI. These two books use the same content, teaching, and practice format but with different software versions, as indicated in the titles. When you read and complete the exercises in this book, Supercharge Excel, you will be learning how to supercharge Power BI at the same time. The DAX language is fully transferable to Power BI.

  • 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() and HASONEVALUE()
  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: KPIs
  19. Concept: Multiple Data Tables
  20. Concept: Cube Formulas
  21. Moving from Excel to Power BI
  22. Next Steps on Your DAX Journey
  • Table of 40 Here's How Sections
  • Appendix A: Answers to Practice ExercisesIndex


Where to Buy

MrExcel Bookstore

eBook from MrExcel.

Add to Cart »

MrExcel Bookstore

Print book from MrExcel.

Buy Now »

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.


Related Products


M is for (DATA) MONKEY

December 2015

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.