2nd Edition of the #1 Selling Power Pivot Book: Now with Power BI, and in FULL COLOR!

Our brand new book covering Power Pivot and Power BI is now available for immediate purchase at MrExcel.com.
Download Book Sample Files here. Submit Errata.
You may also order from Amazon



The First Power Pivot Formulas Book Written Specifically for Excel Users

DAX Formulas for PowerPivot: The Excel Pro's Guide to Mastering DAX

PowerPivot’s formula language (DAX) was created by Microsoft to turbocharge Excel’s existing capabilities.  It puts truly revolutionary power in the hands of YOU, the “spreadsheet heroes” of the world.

DAX Formulas for PowerPivot is the Excel user’s ideal roadmap for harnessing PowerPivot’s career-changing capabilities, utilizing the style developed and refined during Rob Collie’s 3+ years of training fellow Excel users on PowerPivot:

1. Example-Driven:  each concept, function, and technique is accompanied by a tangible example.  Everything is both explained AND demonstrated.

2. Visual – the book features more than 300 illustrations, diagrams, and screenshots.  You SEE everything.

3. Jargon-Free – no prior experience required with programming or business intelligence technologies.  If you’ve created a PivotTable before, you are ready.

Buy the Book or E-Book

Buy from MrExcelBuy from AmazonAustralian Customers!

Reader Reactions

“The style of the book is very visual and easy going, there are no dry explanations of database concepts or theory, it’s all about real examples of everyday data analysis problems and how to solve them using DAX. Also included are the little tricks and tips… which you are unlikely to see in any of the more theoretical books.”-Jacob Barnett, Commercial Analyst (Australia)
“Despite being a fairly accomplished Excel pro, I have been unable to wrap my arms around DAX. But that is over. Four days of working through this book with my own data and I am now making some damn cool stuff that eluded me before.”-Ken Puls, Founder of ExcelGuru and Microsoft-Recognized Excel MVP (Canada)
“Human… this is how technical books should be written.”-Tom LaRock “…writing style is very addictive… it’s a real page-turner.”-Siraj Samsudeen
“Rob has a gift for explaining things in a way that makes it easy to understand.”-Shawn Frizzell “…extremely well written, clear, concise and flows logically down your DAX adventure.”-Dave Boylan
“This book gets to grips with the real problems faced when implementing a powerpivot solution. The section on performance was especially worthwhile and the examples meaningful.”-Dave Pitts “Packed with loads of super useful tips and tools. After getting through the first chapters I had already gotten my money’s worth. Best gift to data analysis in the 21st century.”-Dan Wesson

Sample Contents


This diagram from an early chapter of the book illustrates Rob’s
“Learn incrementally and at your own pace” philosophy

clip_image002_thumb5 clip_image0024_thumb5 clip_image0026_thumb5

A Few Sample Pages – Click Each for Larger Version

Data Sources and Workbooks From the Book

PowerPivot Book Sample Files

All Files Used in the Book Are Available for Free Download
Click Image to Visit the Download Page