Migrating Excel Project to PowerBi. SumProduct Formula used for 4 week moving average. [Expert req]

[ffan]

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

[Ashish_Mathur]

Hi,

The SUMX() function should work.  To get specific help, share some data and show the expected result.

[v-danhe-msft]

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