I know this must be simple and it’s a variation on a theme that many people have raised but the answers don’t seem to help me.
Now, the task is to create a forecast.
Give me the actuals for the months where there are actuals +
ADD the forecast ONLY for the months where there are no actuals.
I have 2 key measures. One calculates actuals based on a lot of filters. It uses the key measure [sum[actual] (actual is column in the fact table)
Measure 2 is the same measure but uses a different key measure [sum[budget]. (budget is another column in the fact table)
Should be simple, shouldn’t it?
I can get the figures for each based on a max date variable.
BUT, no matter what I try, I cannot get totals.
I know it’s to do with no filter context, but WHAT to do, escapes me. I have tried sumx and values but I get ALL the values for budget figures.
Any and all help would be mega appreciated.