DAX Formulas for PowerPivot: A Simple Guide to the Excel Revolution

Front Cover
Tickling Keys, Inc., Dec 1, 2012 - Computers - 239 pages
0 Reviews
Microsoft's Power Pivot is an add-on to Excel that enables you to produce new kinds of reports and analyses that were simply impossible before. This book is the first to tackle DAX formulas, the core capability of Power Pivot, from the perspective of the Excel audience. Written by a leading Power Pivot educator (and former leader on the Power Pivot and Excel teams at Microsoft), the book's concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere.The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. In this book you will learn how Power Pivot:1) Gives you "portable" formulas that can be re-used across multiple different reports with a single click.2) Removes the need to ever write a VLOOKUP formula again.3) Allows you to add smart calculations to pivots, such as "Year over Year" and "Moving Averages" which auto-adjust as the pivot changes.4) Effortlessly merges disjointed sets of data into unified insight.As a bonus, Power Pivot and DAX formulas are both the heart AND brain of Microsoft's "Power BI" system, giving us a long-needed bridge between the worlds of Excel and Business Intelligence – a bridge that any Excel PivotTable user can cross with the help of this easy-to-follow book. Your new career – and your organization's future – starts within these pages

What people are saying - Write a review

We haven't found any reviews in the usual places.


2 What Version of PowerPivot Should You Use?
3 Learning PowerPivot The Excel Way
4 Loading Data Into PowerPivot
5 Intro to Calculated Columns
6 Introduction to DAX Measures
7 The Golden Rules of DAX Measures
8 CALCULATE Your New Favorite Function
9 ALL The Remove a Filter Function
15 IF SWITCH BLANK and Other Conditional
16 SUMX and OtherX Iterator Functions 17 Multiple Data Tables
Advanced Use of FILTER
How to keep things running fast
20 Advanced Calculated Columns
One Click That Will Change Your Life Forever
A1 Further Proof That the Game is Changing
Further Capabilities

10 Thinking in Multiple Tables
11 Intermission Taking Stock of Your New Powers
12 Disconnected Tables
Continued 14 Introduction to Time Intelligence
A3 Four Common Error Messages
The Most Powerful Feature of PowerPivot

Other editions - View all

Common terms and phrases

About the author (2012)

A former Microsoft engineering leader, Rob Collie is an entrepreneur, author, and consultant who believes Excel is enjoying a renaissance in power and importance - a trend that provides massive opportunities for the millions of Excel practioners worldwide. His passion is empowering and the Excel Professional to seize those opportunities. When he's not training, consulting, or writing, Rob can be found in his laboratory, devising new tools and techniques for the Excel community. He also operates the world's leading PowerPivot website (PowerPivotPro.com) and occassionally sleeps.

Bibliographic information