cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
weicaomis123
Frequent Visitor

Calculate Extended Rolling Average using previous 5 months data

Hello

I am trying to calculate the projected rolling average using the previous months data as in my table below.

 

weicaomis123_1-1615576294329.png

 

e.g.
I have the data for car sales January to September, but I would like to estimate the values for October-December using the last five months rolling average.
So October will use the sales from (May-September), November will use the sales from (June - Septmber + the rolling average calculated for October)...and so on.

I would like to extend it to 2021 as well - So that I can use the projected values in the 2021 table as well.

The problem I am facing is if I write a measure for the data to calculate the rolling averages - my 2021 table breaks as it cannot access the calculated measure for 2020 ?

 

Can you please help me with the dax query?

 

Thanks in advance

0 REPLIES 0

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors