Strategies:
Using the Class DIMENSION as an example, there are two ways to change or modify a step:
We use the advanced editor in lieu of the manual steps above, OR in conjunction. If you remove columns, the alias name you gave it can only be "erased" through the advanced editor.
We highlighted the "LinkForClassID" to spotlight the fact that linking fields should never be removed - it is the connection to the FACT table.
Two additional applied steps appear for Account Dimensions in Flexible Period Data Models
We followed two strategies in the Calendar Dimensions
Tactic One
Tactic Two
Tactic Three
NOTE:
These follow the same applied step rules as list dimensions.
Please enable JavaScript to use file uploader.
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/6176/power-query-conventions
Your session has expired. You are being logged out.