Skip to Content
0
Former Member
Mar 30, 2011 at 06:50 AM

Calculating average of last 13 weeks

422 Views

Hi experts!

I have a measure: [sales] detailed at week level.

My requirement is to, for each week, make an average of the last 13.

Week Sales

20 - average of sales of weeks 8 to 20

21 - average of sales of weeks 9 to 21

22 - average of sales of weeks 10 to 22 , etc

I'm stucked here. Has anyone any idea to do that?

Thanks a lot!!