topic Re: Rolling average for last 3 months in DAX Commands and Tips

Rolling average for last 3 months

Anonymous — Fri, 09 Aug 2024 03:27:08 GMT

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!!

Re: Rolling average for last 3 months

Joe_Barry — Fri, 09 Aug 2024 05:30:28 GMT

Hi Anonymous

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

Joe

Re: Rolling average for last 3 months

Anonymous — Tue, 10 Sep 2024 02:43:42 GMT

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