Part V: Understanding Power Pivot and Power Query
- Use the option to alter the formatting of the column as you see fit.
FIGURE 37.3
You can use the formatting tools found on the Power Pivot window’s Home tab to
format any column in the data model.
Veterans of Excel PivotTables know that changing PivotTable number formats one data field at a time is a pain. One
fantastic feature of Power Pivot formatting is that any format you apply to your columns in the Power Pivot window
will automatically be applied to all PivotTables connected to the data model!
Referencing calculated columns in other calculations
Like all calculations in Excel, Power Pivot allows you to reference a calculated column as a
variable in another calculated column. Figure 37.4 illustrates this with a new calculated col-
umn called Gross Margin. Notice in the Formula bar that the calculation uses our previously
created [Total Revenue] calculated column.
FIGURE 37.4
The new Gross Margin calculation uses the previously created [Total Revenue] calculated column.
