Forum Discussion
Forecasting future month using previous 3 month average
Hi Anonymous,
Based on my test, I am afraid you could not calculate the rest of the months due to you must have indeed data for your rest of month.
Regards,
Daniel He
Thank you v-danhe-msft for your reply!
I didn't just want to calculate run rate for December 2018, I am trying to calculate the run rate for all the months remaining in the date list, using the average of previous 3 months. For example, Jan 2019 run rate = (Oct 2018 + Nov 2018 + Dec 2018)/3, Feb 2019 = (Nov 2018 + Dec 2018+ Jan 2019)/3. I can only get as far as Dec 2018, is there any way I can calculate the rest of the months?
Thank you. Really appreciate your help.
Microsoft EmployeeHi Anonymous,
Based on my test, I am afraid you could not calculate the rest of the months due to you must have indeed data for your rest of month.
Regards,
Daniel He
- v-danhe-msft
Hi Anonymous,
It's pleasant that your problem has been solved, could you please mark my reply as Answered to close this topic?
Regards,
Daniel He
Hello,
Have you found any solution that works for this situation?I have the same request and I am struggling for 3 days already 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!
