Part V: Understanding Power Pivot and Power Query
FIGURE 39.22
Pivoting the Month and Revenue columns
Before finalizing the pivot operation, Power Query will activate a dialog box to confirm the
value column and the aggregation method (see Figure 39.23). By default, Power Query will
use the Sum operation to aggregate the data into the matrix format.
FIGURE 39.23
Confirm the aggregation operation to finalize the pivot transformation.
You can override this default by selecting a different operation (Count, Median, Minimum,
and so on). You can even specify that you don’t want any aggregation performed. Click OK
to finalize the pivot operation.
