max of rolling average per day

[giorgiokatr]

i have a table with rows per day and the rolling average of every day (minus 3days)

rollingAvg =
VAR NumOfMonths = 3

VAR LastCurrentDate =MAX ( 'Table'[date])

VAR Period =DATESINPERIOD ( 'Table'[date], LastCurrentDate, - NumOfMonths, DAY )

VAR Result = CALCULATE (  AVERAGEX ( VALUES ( 'Table'[date] ), AVERAGE('Table'[value])), Period )

RETURN

   Result

i would like to have the max of those values for the last 20 days (the max of everyday rolling average) 

i used 

Measure = MAXX('Table',[rollingAvg])

but it gives me wrong results

[amitchandak · Accepted solution]

@giorgiokatr , Try like

calculate(MAXX(values('Table'[Date]),[rollingAvg]), DATESINPERIOD ( 'Table'[date], MAX ( 'Table'[date]), - -20, DAY ))

[giorgiokatr]

@amitchandak thanks! worked like charm!