Part V: Understanding Power Pivot and Power Query
- Use the Operation drop-down list to select the kind of aggregation you want
to apply (Sum, Count Rows, Average, Min, Max, and so forth). In Figure 39.30, we
have chosen to apply Sum.
- Use the Column drop-down list to choose the column that will be aggregated.
In this case, it’s 2018 Potential Revenue.
- Click the OK button to confirm and apply your changes.
Figure 39.31 illustrates the resulting output.
FIGURE 39.31
The resulting aggregate view by State and City
When you apply the Group By feature, Power Query removes all columns that were not used when configuring the
Group By dialog box. This leaves you with a clean view of just your grouped data.
