Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
From the author of Adding DAX Calculations to the PivotTable

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.

  • + Share This
  • 🔖 Save To Your Account