Forum Discussion
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...
Hey thanks for you answer, I tried that DAX function and adjusted slightly because it would give me an error
Average over the past 30 days = CALCULATE(Total = SUM(Data[Value]),DATESBETWEEN(Calendar[Date],MIN(Calendar[Date])-30,MIN(Calendar[Date])))
It worked but the numbers that it gave me are much lower than what the averages actually should be.
Thanks again
Hi,
I will need to see your file to know the error you are committing. Also, please meniton there what the correct answer should be.