Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Lu1sT0rr3s
Frequent Visitor

Weekly Rolling Average

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
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

6 REPLIES 6
v-easonf-msft
Community Support
Community Support

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

Hello 

 

Try this one

@Lu1sT0rr3s 

 

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@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.

 

 

Capture.PNG

 

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

amitchandak
Super User
Super User

@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.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Greg_Deckler
Super User
Super User

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.