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
  • Paperback: 224 Pages
  • Publisher: Holy Macro! Books
  • Print 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
  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
  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 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