Star scheme

[Zerp1983]

Hi,

building my first model and I got stuck. I have Actuals fact table conected to Chart of accounts Dim through Account field. Dimension table has data organized on three levels (account, group, subgroup) and I have Calendar table apart. The problem comes when I add Forecast table that has data only on Subgroup level. How to connect it with Actuals? I tried to put it together with AC data in Excel (Account,Subgroup,Amount,date,type(AC/FC), but as my FC has only data on subgroup level filter context doesn't function for FC data. Guess the problem is M:M relation on subgroup level. Any idea/resource link how to tackle this granularity?

thanks

[v-rongtiep-msft]

Hi @Zerp1983 ,

Please refer to the following document to see if it helps you.

Showing actuals and forecasts in the same chart with Power BI 

• The Forecast measure in the demo model is quite an advanced piece of DAX code that would require a full article by itself. The curious reader will find more information on how to reallocate budget at different granularities in the video Budgeting with Power BI. 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bcdobbs · Accepted solution]

This might be a good place to start:
Budgeting with Power BI - SQLBI