Weekly Rolling Average

[Lu1sT0rr3s]

Hello All

I try to calculate a rolling average by week and it seems that it work the formula that I try, however when the calculation goes to week 52 the calculation finished there, does not follow the next year.

The formula that I used was:

12Wk EMA Preload =

CALCULATE([AVERAGE PEAK FORCE],

FILTER(ALL(WYLIE),

WYLIE[Week Number] = SELECTEDVALUE(WYLIE[Week Number]) -12))

Any help will be greatly appreciated.

Attached is my power bi project

[v-easonf-msft]

Hi , @Lu1sT0rr3s 

Your pbix url seems invalid or  I don't have access to your file. Can your  reshare your pbix file  if it is convenient.?  

Best Regards,
Community Support Team _ Eason

[Lu1sT0rr3s]

Hello 

Try this one

[amitchandak]

@Lu1sT0rr3s 

can you share on which formula/visual, what is the expected output

[Lu1sT0rr3s]

@amitchandak 

I solve my problem with the rolling average per week, however there is another problem, I need the rolling average of a measure that I create, the measure is called MACD WEEK.

I would like to calculate the rolling average of 9 points of that measure in the same way, per week.

[amitchandak · Accepted solution]

@Lu1sT0rr3s 

Please refer to my file. I t use rank on week start date to calculate 12 weeks rolling

https://www.dropbox.com/s/9agcbser2sqk02s/sales_analytics_weekWiseFriday_thru.pbix?dl=0

Appreciate your Kudos.

[Greg_Deckler]

Perhaps try using Sequential in the Quick Measures gallery to make this easier.