Forum Discussion
mixue100
3 years agoFrequent Visitor
Using rolling last 3 months average for forecast into future months
Hi all
I am trying to use my last 3 months average to get a forecast for the future.
For example
month $
Jan 22 =1000
feb 22 =1200
mar 22 =900
aug 22 =200
sept 22 =500
oct 22 =900
Nov 22= 1100
Dec22 = Not know yet. I would need forecast to be the average of sep 22 to nov 22, say (500 + 900 + 1100) /3
Jan 23 = Average of Oct 22 - Dec 22
Feb 23 = Average of Nov 22 - Jan 23
..
..
Dec 23 = Average of Sep 23 - Nov 23
Is there any dax formulas which I can apply to achieve this ? Thank you so much!
2 Replies
- amitchandakSuper User
mixue100 , I really doubt that, unless you have a fixed month to forecast
- mixue100Frequent Visitor
Hi,
I like to forcast till end dec 23