Hey
my question concerns a very common situation in many businesses. It is quite easy to build a measure based on historical data, e.g. the average share of products within a Brand, segment etc for a given period - up to the level of granularity defined in the look-up table. But what if we get a plan/forecast for the next year written down to the level of e.g. Brand - and based on historical shares we want to break down the forecast by products - although we only have Brandy at our disposal. In Excel, it is not difficult - but in Power BI? Maybe someone has an idea
Best regards
Piotr
my question concerns a very common situation in many businesses. It is quite easy to build a measure based on historical data, e.g. the average share of products within a Brand, segment etc for a given period - up to the level of granularity defined in the look-up table. But what if we get a plan/forecast for the next year written down to the level of e.g. Brand - and based on historical shares we want to break down the forecast by products - although we only have Brandy at our disposal. In Excel, it is not difficult - but in Power BI? Maybe someone has an idea
Best regards
Piotr
