Forum Discussion
JonathanJohns
9 years agoHelper III
Running Average for three weeks
Good afternoon, I have a problem to do a formula with Power BI Desktop. I had a look on the forum to find my answer but I was not able to do the operation. I have a table like this one with d...
Greg_Deckler
9 years agoCommunity Champion
Take a look at my article here:
https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
You will need to create another measure that takes the average of averages with an appropriate filter but this technique should work.
- JonathanJohns9 years agoHelper III
I read your article but I didn't understand how did it in my case... Sorry
How is it possible to calculate a running average for three weeks please ?