Chapter 37: Adding Formulas to Power Pivot
37
- Power Pivot will automatically rename the column to Calculated Column 1.
Double-click the column label, and rename the column Month. - Starting the next column, click the first blank cell in the empty column labeled
Add Column on the far right. - In the Formula bar, type =FORMAT([InvoiceDate],"mmm") and then press
Enter. - Power Pivot will automatically rename the column to Calculated Column 1.
Double-click the column label and rename the column Month Name.
After going through these steps, you should have three new calculated columns similar to
the ones shown in Figure 37.10.FIGURE 37.10
Using DAX functions to supplement a table with Year, Month, and Month Name columnsAs mentioned, creating calculated columns will automatically make them available through
your PivotTable Fields list (see Figure 37.11).FIGURE 37.11
DAX calculations are immediately available in any connected PivotTable.