Forum Discussion

ffan's avatar
ffan
Regular Visitor
8 years ago

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

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

 

 

2 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

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