Forum Discussion
4 week rolling average
Hi, I need to be able to create a 4 week rolling average off of calendar weeks from Monday start to Sunday end. So if I opened the report on a Wed I need to make sure the calculation cuts off on ...
jnrezk , You need to create measures for rolling
Avg = CALCULATE(AverageX(values('Date'[Week Rank]), calculate(sum('Table'[Qty])) ), FILTER(ALL('Date'),'Date'[Week Rank]>=max('Date'[Week Rank])-5 && 'Date'[Week Rank]<=max('Date'[Week Rank]) -1 ))
a new column will be like
CALCULATE(sum('Table'[Qty]), FILTER(('Table'),'Table'[Week Rank]>=earlier('Table'[Week Rank])-5 && 'Table'[Week Rank]<=earlier('Table'[Week Rank]) -1 ))
amitchandak This is what I already did - can you check my file I linked and let me know what adjustments I should make?
jnrezk , Please provide access
Hi, amitchandak I gave access - do you have it now?