Forum Discussion
13 Week Rolling Average Graph with Daily %
Just noticed the table was formatted slightly off. Here you can see more clearly.
Have you looked at my rolling weeks Quick Measure?
https://community.powerbi.com/t5/Quick-Measures-Gallery/Rolling-Weeks/m-p/391694
No I hadn't seen it. I'm not well versed in DAX and don't know how to extract knowledge from there.
The two key differences that I see comparing it with my data are:- I have VALUES that I'd like to average
- I have different THINGS for which I want to find the average separately.
Nevertheless thank you for your response.
Hi,
Try this
- Create a Calendar Table by writing the following formula in Modelling > New Table =CALENDAR(MIN(Data[Date]),MAX(Data[Date]))
- Create a relationship from the Date column of the Data Table to the Date column of the Calendar Table
- Drag Date from the Calendar Table in your visual
- Drag Thing from the Data Table into the visual
- 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.
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 againHi,
I will need to see your file to know the error you are committing. Also, please meniton there what the correct answer should be.
