Microsoft Office Tutorials and References
In Depth Information
FIguRE 2-21 The new decoding table in the PowerPivot selector.
You now see a new table inside the Field List, named SalesOrderHeader_OnlineOrderFlag,
with two columns (one of which is a technical one that you should hide later). The Order Type
column in this new table does the same task that was accomplished by the Order Type in the
SalesOrderHeader table. The difference now is that it is much easier to change the descriptions
because they are not hard-coded in a DAX formula but contained in a table hosted inside the
Excel workbook. This means that changing the descriptions is now a simple task for anyone,
and no one has to understand what is going on with the code.
Let us stop for a few seconds and think about what you have done.
■ You have been able to mix different sources of data into a single coherent view of
information, shaping the data model to make it it your needs.
■ You have provided your users (and yourself) an easy way to give descriptions to
technical values, making the process of browsing the PivotTable and producing
reports more intuitive.
■ You created your first piece of a data model—that is, a model of data that describes
the entities you intend to browse.
The only drawback of this solution is that, if many fields require a lookup table, the field
selector of the PivotTable might become a little messy because too many tables start to
appear inside it. Luckily, there is a simple solution to this: you can use the RELATED function
in DAX, something you are going to learn later in this chapter.