Microsoft Office Tutorials and References
In Depth Information
Differentiating Columns in Multiple Dates Tables
Duplicating the same table, such as a Dates table, multiple times in a PowerPivot model
makes the resulting PivotTable difficult to read whenever the same attributes are used from
different tables. For example, in Figure 7-19, you can see a PivotTable in which the Year from
OrderDate has been put in rows and in the first slicer, and the Year from ShipDate has been
put in columns and in the second slicer. The problem is that there is no evidence of the
table that a column belongs to whenever it is moved into slicers, filters, rows, or columns
of the PivotTable. The final model for the example of this section is available in the
CH07-03-PrefixedDateColumns.xlsx workbook included on the companion DVD.
FIguRE 7-19 Columns with the same name from different tables are not recognizable in a PivotTable.
So in case you create a model with multiple copies of the same tables, you should differentiate
the names of the columns so that they are immediately recognizable in a report. You can edit the
table names in Excel by adding a prefix to each column. In Figure 7-20, you can see the heading
of the OrderDate table, wherein each column has been prefixed with the word Order . You can
do the same for the ShipDate column by using the Ship prefix.
FIguRE 7-20 The columns of OrderDate prefixed with Order .