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
Microsoft EmployeeHi Anonymous,
From your description, you could refer to below stpes to sum previous month value:
Add an index column in query editor:
Create below measure:
Measure = CALCULATE(SUM(Table1[Run Rate]),FILTER(ALL('Table1'),'Table1'[Index]<=MAX('Table1'[Index])&&'Table1'[Index]>=MAX('Table1'[Index])-2))
Result:
But I could not figure out how could you want to calculate for 'Run Rate ' in 2018 December? Due to the value in Power BI is based on one whole column, you could not just calculate for different rows.
You could also download the pbix file to have a view.
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.
- v-danhe-msft
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