Part V: Understanding Power Pivot and Power Query
FIGURE 37.19
Calculated measures can be seen in the PivotTable Fields list.
Editing and deleting calculated measures
You may find that you need either to edit or to delete a calculated measure. You can do so
by following these steps:
- Click anywhere inside your PivotTable and then click the Power Pivot tab in
the Excel Ribbon and select Measures ➪ Manage Measures. This will open the
Measure dialog box shown in Figure 37.20.
FIGURE 37.20
The Manage Measures dialog box lets you edit or delete your calculated measures.
- Select the target calculated measure, and click either the Edit or Delete button.
Clicking the Edit button will activate the Measure dialog box where you can make changes
to the calculation setting.
