- Downloading and Installing PowerPivot
- Getting your Data into PowerPivot
- Linking an Excel Table to PowerPivot
- Importing Data into PowerPivot
- Adding DAX Calculations to the Grid
- Creating Pivot Tables from PowerPivot
- Defining a Relationship Between Worksheets
- Using Automatic Relationship Detection
- Using Explicit Relationships
- Using the RELATED Function in the PowerPivot Grid
- Adding Slicers to Drive All Pivot Elements
- Adding DAX Calculations to the PivotTable
- Entering a Measure
- Using the X Functions
- Using CountRows and Distinct
- PowerPivot Is a Home Run
Adding DAX Calculations to the PivotTable
Have you ever tried to create a calculated field in a pivot table? Only about 1 out of every 500 people have tried using calculated fields in a pivot table. Out of that group, about a quarter of them run into a wall where traditional Excel pivot table calculated fields could not solve their problem. If you happen to fall into the group of people who hit such a wall, you are going to love the new Measure feature in PowerPivot pivot tables.
Some of the new DAX functions are specifically designed to work with Measures in the pivot table. Unlike calculations in the PowerPivot grid, measures are only calculated once per cell in the resulting pivot table.
In the following pivot table, a Measure would only be calculated 15 times.