Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I run an Excel report. I then populate a chart using a 4 week weighted moving average,
To do this I use this formula: SUMPRODUCT(AO3:AR3, AO4:AR4)/SUM(AO4:AR4)
A03 would be the average for Week 27. AP3 would be the average for Week 28.
AQ4 would be the count for Week 27. AP4 would be the count for Week 28.
How would I replicate this 4 week weighted moving average in PowerBi?
Many thanks for your help
Hi,
The SUMX() function should work. To get specific help, share some data and show the expected result.
Hi @ffan,
Due to I could not figure out your data structure, could you please post me some sample data or picture and offer me your desired result?
Regards,
Daniel He
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
73 | |
62 | |
61 |