Syntax improvement question - Average of last measures

[data_RN]

Hi All, 

I hope this is an easy one for a Friday, but I have tried this a few ways and haven't been able to figure it out.  I want the average score of the last few days.  I get the right answer with the formula below, but is there a more elegant way to set it up?

(sum({$<[Approval Date]={"$(=Date(Max(Date,3)))"}>}[Score Actual])+
sum({$<[Approval Date]={"$(=Date(Max(Date,4)))"}>}[Score Actual])+
sum({$<[Approval Date]={"$(=Date(Max(Date,5)))"}>}[Score Actual])+
sum({$<[Approval Date]={"$(=Date(Max(Date,6)))"}>}[Score Actual]))/4

Thanks as always!

[dplr-rn]

how about something like below

sum({$<[Approval Date]={"<=$(=Date(Max(Date,3))) >=$(=Date(Max(Date,6)))"}>}[Score Actual]) / 4

[tm_burgers · Accepted solution]

I think that the below will work for you:

AVG(AGGR(nodistinct sum({<[Approval Date]={">=$(=Date(Max(Date,6)))<=$(=Date(Max(Date,3)))"}>} [Score Actual]),[Approval Date]))

[data_RN]

@tm_burgers that was it!

Thank you and Happy Friday!!!