This example provides support for actual versus budget analysis in a model containing different grains.
- Create the bridge tables
- Budget Product Categories and Budget Dates bridge tables are added to the model at the grain of the budget
- Each table contains the unique values of the dimension at the grain of the Budget table
These bridge tables can potentially leverage the existing M queries in the model used to load the dimension tables. For example, the following M expression references the Date table query as it's source and selects only the distinct values of the Calendar Yr-Mo column. If this is the grain of the budget table, this single column table could be used as the bridge table.
let Source ...