Actual versus budget model and measures

This example provides support for actual versus budget analysis in a model containing different grains.

  1. 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 ...

Get Microsoft Power BI Cookbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.