Forum Discussion
Solved
How to create a 13 week rolling average based on date hierarchy
Hi, I am wondering if there is a way to create a rolling average measure that would show the rolling average of the last 13 weeks on a bar chart visual. The X axis of my chart is a date hierarchy tha...
Hi cardweller ,
Based on your description, I have created a simple sample:
Please try:
Measure = var _a = WEEKNUM(MAX('Table'[Date])) var _b = FILTER(ALL('Table'),WEEKNUM([Date])>=_a-12&&WEEKNUM([Date])<=_a) return AVERAGEX(_b,[Column])Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jianboli-msft
Community Support
Community SupportHi cardweller ,
Based on your description, I have created a simple sample:
Please try:
Measure =
var _a = WEEKNUM(MAX('Table'[Date]))
var _b = FILTER(ALL('Table'),WEEKNUM([Date])>=_a-12&&WEEKNUM([Date])<=_a)
return AVERAGEX(_b,[Column])Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.