Forum Discussion
Forecast average 3 months with current data
Hi how to create a forecast with currecnt data :
1. ACTUAL SALES : current data from Jan-Jun
2. FORECAST SALES : combination ACTUAL SALES (Jan-Jun) and FORECAST (Jul-Des)
FORECAST (Jul-Des) is AVERAGE LAST 3 MONTH data example : Jul : Average (Apr-Jun), August (May-Jul),... Dec (Sep-Nov)
3.FORECAST SALES POSITIVE (*10%) = FORECAST SALES + (FORECAST SALES * 0.1)
4.FORECAST SALES NEGATIVE (* -10%) = FORECAST SALES + (FORECAST SALES * -0.1)
All input will be helpful
3 Replies
Would you like this in Power Query or DAX? Calculated Column or Measure?
Hello,
Have you found any solution that works for this situation? I have the same request and I am struggling for 3 days to make it work. I can just allocate the average of the last 3 months with data, to the rest of the future months, but what I actually need is a dynamic cascading of the 3 months average for future months. I think this is what you are also trying to achieve.
Thank you!
