How to get a MIN, MAX, and Median on a rolling average measure?

[sarhutson]

I have a measure that calculates 'Chargeback % Incurred' by month. I created a new measure called 'Rolling 3 Mo Avg' it looks at current month and the past 2 and returns an average accross the 3. This is where im getting stumped... I need to take the rolling 3 month minimum of the already rolling 3 month average. I'm not sure how to do a rolling minimum or max on a rolling average. 

My example:

The MIN of the rolling 3 average - the 1.05% is the minimum of the past 3 months rolling 3 month average (2.21, 1.65, 1.05) the same the with the MAX column. 

Chargeback % Incurred measure: 

sum('Analysis Table'[Total Chargebacks]) / sum('Analysis Table'[Total Fundings])

Rolling 3 Mo Avg = IF(

    SELECTEDVALUE('Date Table'[MonthInCalendar]) in ALLSELECTED('Date Table'[MonthInCalendar]),

    CALCULATE(

        DIVIDE (-SUM('Analysis Table'[Total Chargebacks]), SUM('Analysis Table'[Total Fundings])),

        DATESINPERIOD(

            'Date Table'[Date],    LASTDATE('Date Table'[Date]),      -3,MONTH )))

[amitchandak]

@sarhutson , Try if this can help

sample measure 

Max 3 Month Avg = Maxx(Values('Date'[MONTH Year]), CALCULATE(AverageX(Values('Date'[MONTH Year]),calculate(Sum('Table'[Value)))
,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH)) ,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))

[sarhutson]

Hey @amitchandak Im not sure if I did this correctly but I'm not seeing the results I would expect. 

Max 3 Month Avg = Maxx(Values('Date Table'[MonthInCalendar]), CALCULATE(AverageX(Values('Date Table'[MonthInCalendar]),calculate([Chargeback %]))

,DATESINPERIOD('Date Table'[Date],MAX('Date Table'[Date]),-3,MONTH) ,DATESINPERIOD('Date Table'[Date],MAX('Date Table'[Date]),-3,MONTH)))

I would expect 2.21% for Jan 2023