Rolling average for last 3 months

[Anonymous]

I am trying to get average of last 3 months for Status% using this code but its not giving correct average. I am using measure and Status%  is also measure

Rolling 3M Avg =

VAR Period =

    DATESINPERIOD(

        'TestBoard'[Exec Date],

        MAX('TestBoard'[Exec Date]),

        -3,

        MONTH)

RETURN

CALCULATE(

    AVERAGEX(

        VALUES('TestBoard'[Exec Date]),

        [Status%]),

    Period)

Can you please advise whats going wrong here.. Thanks in advance!!

[Anonymous]

Hi @Anonymous ,

Has the issue been solved?
Have there been any updates? Please feel free to ask me if you have any questions!

If your issue has been resolved, please mark the resolution responses as solutions.

Best Regards,
Dengliang Li

[Joe_Barry]

Hi @Anonymous 

Please refer to my answer here https://community.fabric.microsoft.com/t5/Desktop/rolling-3-months-sum/m-p/4070303#M1290389

Joe