What if based on previous month result (forecast scenario)

[MaleneL]

what if based on previous month result (forecast scenario)

Hi all

Once again, I need help.

I am trying to create at forecast for next year, based on the ending result last year.

I know how to find my January result, by using my ending result for last year (see the below measurment). But what I cannot figure out, is how to make a calculation (VAR) that says take January figures and race it with lets say 1% (I have made the “what if parameter” with % ([change_%])) and after that take the January and race that with the same % in february and so on.
So all in all I need to change the zero in the return statement ;O)

Budget_Andele =

VAR _BudgetFirstMonth =

CALCULATE (

    [Forecast_Andele_Combine],

        DATEADD(Dim_Kalender[date], -1, MONTH))*(1+[change_%])

 Return

IF (ISBLANK(_BudgetFirstMonth),0, _BudgetFirstMonth

    )

hope sombody can help

Malene