Forum Discussion
Running Average for three weeks
Hi Anonymous
Thanks for your answer. I have done the script you did and I got this table :
Concerning the column "Running Average", I wanted to know how it's possible to get a column like that please :
| Week | Average | Index | Running Average |
| 0017-W09 | 60,374171 | 1 | NA |
| 0017-W10 | 60,322105 | 2 | NA |
| 0017-W11 | 60,224279 | 3 | 60,30685167 |
| 0017-W12 | 60,26567 | 4 | 60,27068467 |
| 0017-W13 | 60,153548 | 5 | 60,214499 |
The value 60,306851167 is the average of the 3 values from the weeks W09,W10,W11.
The value 60,27068467 is the average of the 3 values from the weeks W10,W11, W12.
The value 60,214499 is the average of the 3 values from the weeks W11,W12,W13.
I hope you know what I mean, I tried all my laste friday but it looks a little bit confused for me.
Thank you for your help.
Jonathan
Hi JonathanJohns,
Do you create newtable using the first formula? And do you right click the newTable and select "New Column" to apply the third formula?
Thanks,
Lydia Zhang
I have done like you said. I created a new table with the DAX, then created the colum"Index" and finally the column "Running Average" and I got the last table.
Hi JonathanJohns,
The formulas work as expected in my scenario, could you please share me all the data in your original table so that I can test?
Thanks,
Lydia ZhangHow can I do to send you my data please ?