Forum Discussion
4 week moving average
Anonymous
Take a look at these threads that I solved more or the less the same issue
https://community.powerbi.com/t5/Desktop/Moving-Average-Calculation/m-p/659153
https://community.powerbi.com/t5/Desktop/Moving-average-starts-at-zero/m-p/678956
https://community.powerbi.com/t5/Desktop/Rolling-8-weeks-avg-for-weekly-monthly-quarterly/m-p/750305
Hi Anonymous ,
Have you solved your problem?
If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please show your sample data in text-tabular format in addition to (or instead of) screen captures. That allows people trying to help to readily copy the data and run a quick test, plus it increases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (beware of confidential data).
Best Regards
Cherry