MrExcel Publishing
Your One Stop for Excel Tips & Solutions

DAX Formulas for PowerPivot

December 2012

DAX Formulas for PowerPivot

The Excel Pro's Guide to Mastering DAX by Rob Collie

This is the book that opened my eyes about how PowerPivot transforms Excel into much more than a spreadsheet – and I’m supposed to know something about spreadsheets. It’s a fun read and it will teach you skills that you really need to know, if you’re crunching significant amounts of data in Excel.

Dan Fylstra, President, Frontline Systems

category: Power Pivot
covers: Excel 2010 - 2013

Product Details
  • Paperback: 239 Pages
  • Publisher: Holy Macro! Books
  • Print ISBN: 978-1-61547-015-0
  • PDF ISBN: 978-1-61547-212-3
  • ePub ISBN: 978-1-61547-332-8
  • Mobi (Kindle) ISBN: 978-1-61547-112-6

This Book is written from a traditional “Business Intelligence” standpoint and is aimed at the audiences of BI pros, SharePoint pros, and Network Administrators

Rob Collie

PowerPivot is the Best Thing to Happen to Excel in 20 Years. This book unlocks its secrets for today's Excel users.

Bill Jelen, MrExcel
This is the rare technology that can (and will) fundamentally change the lives of millions of people – it has more in common with the invention of the PC than with the invention of, say, the VCR.

My Two Goals for This Book

Fundamentally of course, this book is intended to train you on PowerPivot. It captures the techniques I’ve learned from three years of teaching PowerPivot (in person and on my blog), as well as applying it extensively in my everyday work.

Unsurprisingly, then, the contents herein are very much instructional – a “how to” book if ever there was one. But I also want you to understand how to maximize PowerPivot’s impact on your career. It isn’t just a better way to do PivotTables. It isn’t just a way to reduce manual effort. It’s not just a better formula engine. Even though I worked on the first version of PowerPivot while at Microsoft, I had no idea how impactful it would be until about two years after I left the company. I had to experience it in the real world to see its full potential, and even then it took some time to overwhelm my skeptical nature (my Twitter profile now describes me as “skeptic turned High Priest.”)

Rob Collie
  • Acknowledgements v
  • A Note on Hyperlinks vii
  • Introduction ix
  • Chapter 1- A Revolution Built on YOU 1
  • Chapter 2- What Version of PowerPivot Should You Use? 7
  • Chapter 3- Learning PowerPivot “The Excel Way” 9
  • Chapter 4- Loading Data Into PowerPivot 13
  • Chapter 5- Intro to Calculated Columns 23
  • Chapter 6- Introduction to DAX Measures 29
  • Chapter 7- The “Golden Rules” of DAX Measures 49
  • Chapter 8- CALCULATE() – Your New Favorite Function 59
  • Chapter 9- ALL() – The “Remove a Filter” Function 69
  • Chapter 10- Thinking in Multiple Tables 75
  • Chapter 11- “Intermission” – Taking Stock of Your New Powers 87
  • Chapter 12- Disconnected Tables 89
  • Chapter 13- Introducing the FILTER() Function, and Disconnected Tables Continued.. 99
  • Chapter 14- Introduction to Time Intelligence 111
  • Chapter 15- IF(), SWITCH(), BLANK(), and Other Conditional Fun 135
  • Chapter 16- SUMX() and Other X (“Iterator”) Functions 143
  • Chapter 17- Multiple Data Tables 151
  • Chapter 18- Time Intelligence with Custom Calendars: Advanced Use of FILTER() 161
  • Chapter 19- Performance: How to keep things running fast 185
  • Chapter 20- Advanced Calculated Columns 97
  • Chapter 21- The Final Transformation: One Click That Will Change Your Life Forever 209
  • A1- Further Proof That the Game is Changing 229
  • A2- So Much Power, So Little Space: Further Capabilities 233
  • A3- Four Common Error Messages 235
  • A4- Supporting Workbooks and Data Sets 237
  • A5- People: The Most Powerful Feature of PowerPivot 238

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 »

Print Book from Amazon:

Print Book from Amazon »

Other Editions

Related Products