Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
1 year ago

Cumulative forecast DAX support

  hi All,   i need a cumulative forecast, from the time where my actuals Ends, as you can see from the below   My current dax is not showing the right output for the month of november it should ...
Need Help
Show and Tell
Rupak_bi's avatar
Rupak_bi
Icon for Super User rankSuper User
1 year ago

HI vjnvinod 

this can be done by creating an index when actual is blank and then multiplying the forcast with index. Try it. else share the data in plain text so that I can copy and build the logic.

Rupak_bi's avatar
Rupak_bi
Icon for Super User rankSuper User
1 year ago

Hi vjnvinod ,

Please see below result in a calculated column. Hope this solves your Purpose.

if this works, please accept as solution.