Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Moving Average using a Measure & Calculated Columns

Hello all, 

I've seen this question posted several times however none of the solutions I've come across have worked. What I want to do is calculate a 4 week/28 day rolling average for five measures. Each of the measures is calculated similarly so I would suspect a solution that works for one will work for all. The data table I am using looks like the image below and is named 'Delivery Performance' (edited for simplicity/confidentiality):

Please note that the columns EDD_numerator through SR_numerator are calculated columns based on other columns within the same table. For example, EDD_numerator is [Expected Delivery Date]*[Deliveries]; the other calculated columns have similar simple calculations. 

I will first need to create a moving average for the following measure:

Expected Delivery Date (EDD) =
DIVIDE(
    SUM('Delivery Performance'[EDD_numerator]),
    SUM('Delivery Performance'[Deliveries])
)

All attempts so far have either resulted in duplicating the measure or creating a moving average that performs the calculation on each individual calendar day, despite all data points being 7 days apart. 

Thank you!
Need Help

1 Reply

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi Anonymous ,

     

    Does the data model have a date table? Also what is the calculation logic of the created EDD_numerator and SR_numerator columns? Is it possible to further describe your requirements.

     

    Looking forward to your reply.


    Best Regards,
    Henry