Need help creating an Average of a rolling measure!

[Anonymous]

Screenshots for info,

What I'm trying to do is make my 'Inventory Measure' become a rolling average of 52 weeks. So using the Rolling periods = L52W would be helpful, but I want my data points in Inventory Measure to become an average of all those 52 weeks at every point, so instead of it drastically going up and down in the first graph, it becomes an average 

[amitchandak · Accepted solution]

@Anonymous , You can get avg like , assuming you have measure M1

Last 52 weeks = CALCULATE(Averagex(Values('Date'[Week Rank]), [m1]), FILTER(ALL('Date'),'Date'[Week Rank]>=max('Date'[Week Rank])-52 && 'Date'[Week Rank]<=max('Date'[Week Rank])))

You need create week rank in your date table

new columns in date table
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
OR
Week Rank RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.