Moving Average using a Measure & Calculated Columns

[Anonymous]

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!

[v-henryk-mstf]

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