Forum Discussion

aortuno's avatar
aortuno
Frequent Visitor
8 years ago

13 Week Rolling Average Graph with Daily %

I know this has been somewhat asked but what I'm trying to do has a slightly different presentaion and I'm having a hard time figuring out how to create a rolling average.   Below is a sample of ho...
Need Help
aortuno's avatar
aortuno
Frequent Visitor
8 years ago

Just noticed the table was formatted slightly off. Here you can see more clearly.

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Try this

 

  1. Create a Calendar Table by writing the following formula in Modelling > New Table =CALENDAR(MIN(Data[Date]),MAX(Data[Date]))
  2. Create a relationship from the Date column of the Data Table to the Date column of the Calendar Table
  3. Drag Date from the Calendar Table in your visual
  4. Drag Thing from the Data Table into the visual
  5. Write these measure

 

Total = SUM(Data[Value])

Average over the past 30 days = CALCULATE([Total],DATESBETWEEN(Calendar[Date],MIN(Calendar[Date])-30,MIN(Calendar[Date])))

 

Hope this helps.