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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Remove the =SUM(Sheet1[VALUE]) from within the CALCULATE() function.

 

Does that help?

aortuno's avatar
aortuno
Frequent Visitor
8 years ago

Not really, it now shows the first three values the same as the first three from the VALUE column (7,6,3) and the rest of the column is empty.


Just to confirm the new formula is: 

 

AVERAGE_CALCULATED = CALCULATE(SUM(Sheet1[VALUE]),DATESBETWEEN('Calendar'[Date],MIN('Calendar'[Date])-3,MIN('Calendar'[Date])))

 

Thanks again

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Share the link from where i can download your workbook.