Granularity Issue with fact tables

[Jameswh91]

Hi, so i've got an issue with the granularity between our inventory table and our budget table. The budget table was produced to product and colour level e.g Pink Baselayer. The inventory table goes to sku level e.g RB0001 = Small pink baselayer. 

The issues i have are: Pink baselayer equals multiple styles so Pink Baselayer may = RB0001 and RB0002. 

So when the budget says to expect 50 sales of pink baselayer in November 2022 i need to caculate the expected units for the month. Is there any way i could do this despite the multiple SKUs and sizes?

[Anonymous]

Hi @Jameswh91 ,

I have found some similar posts, please refer to.

Solved: Budget and actuals at different granularity - Microsoft Power BI Community

Budget allocation: combining different levels of granularity in Power BI - Kohera

How to Get Your Question Answered Quickly 

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.