Forum Discussion

Gian22's avatar
Gian22
New Member
2 years ago
Solved

12m rolling forecast with parameter

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

Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    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))

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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))