MAX of a Rolling Average

[JohnHS]

 Hi I have a measure that calculates a rolling average:

7day Avg =
AVERAGEX (
    DATESINPERIOD ( 'Calendar'[DateKey], LASTDATE ( 'Calendar'[DateKey] ), -7, DAY ),
    [DevAdvance]
)

Now I want to find the MAX of the result set generated by this measure. 

In this result set I can see that the MAX is 17.93 but if I try Max7DayAvg = MAX ( [7day Avg ] ) i get an error that MAX() requires a column.

This is driving me mad please help!

[Anonymous · Accepted solution]

[Max 7D Avg] =
MAXX(
    'Calendar',
    [7D Avg]
)

Best

D