12m rolling forecast with parameter

[Gian22]

Hi Everyone,

I need to calculate the 12m rolling forecast of our sales. 

I know how to calculate the forecast via a "Growth Select" parameter

(GF Sales forecast = [Sales Total] + [Sales Total] * 'Growth Select'[Growth value])

but the forecast calculated should be "delayed" by 12 months. For example in the below capture, the "GF Sales forecast" for September 24 should be  611155,58 (the calculated amount in the September 23 line. 

 I should then be able to calculate the 12m forecast, starting from the next month (September 24 in this case)

Thanks in advance for your help

[Gian22]

Awesome, that is what I was looking for

thanks @amitchandak 

[amitchandak · Accepted solution]

@Gian22 , Assuming you are using date table and the month start is coming from the date table

Year behind GF Sales forecast  = CALCULATE([GF Sales forecast],dateadd('Date'[Date],-1,Year))