Rolling average by day for P3M

[em6jq65]

Hey guys! 

I have a question about calculating rolling average for P3M 

Here is the small example of my dataset:

As you can see here, I have shipments to the same customer at the same date with different sales amount. 

And the result I want to get is attached below. The problem is that i need to calculate all sales for the period and then to calculate average for the P3M period and I dont know how to do it

Thank you guys! 

[v-yulgu-msft · Accepted solution]

Hi @em6jq65,

Please try this measure:

RollingAVR =
CALCULATE (
    SUM ( Table[Amount(pieces)] ),
    FILTER (
        ALL ( Table ),
        Table[Date].[Year] = YEAR ( MAX ( Table[Date] ) )
            && Table[Date].[MonthNo] <= MONTH ( MAX ( Table[Date] ) )
            && Table[Date].[MonthNo]
                >= MONTH ( MAX ( Table[Date] ) ) - 2
    )
)
    / 3

Best regards,

Yuliana Gu