Chapter 37: Adding Formulas to Power Pivot
37
Once you confirm the change, it will initially appear as though nothing happened. This is
because the sort order that you defined is not for the Power Pivot window. The sort order
is applied to your PivotTable. You can flip over to Excel and see the result in the PivotTable
(see Figure 37.14).
FIGURE 37.14
Your month names now show in correct month order.
Referencing fields from other tables
Sometimes the operation you are trying to perform with a calculated column requires you
to utilize fields from other tables within the Power Pivot data model. For instance, you
may need to account for a customer-specific discount amount from the Customers table
(see Figure 37.15) when creating a calculated column in the InvoiceDetails table.
FIGURE 37.15
The Discount Amount value in the Customers table can be used in a calculated column in
another table.
To accomplish this, you can use a DAX function called RELATED. Similar to VLOOKUP in
standard Excel, the RELATED function allows you to look up values from one table to use
them in another.