Dynamic Rolling Quarter Rank

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file whether it suits your requirement.

WINDOW function (DAX) - DAX | Microsoft Learn

RANK function (DAX) - DAX | Microsoft Learn

KEEPFILTERS function (DAX) - DAX | Microsoft Learn

Sales total: = 
SUM( Sales[sales] )

Recent 5 quarters rank: = 
VAR _today =
    TODAY ()
VAR _t =
    SUMMARIZE (
        FILTER ( ALL ( 'Calendar' ), 'Calendar'[Date] <= _today ),
        'Calendar'[Year-Quarter]
    )
VAR _topfive =
    WINDOW ( 1, ABS, 5, ABS, _t, ORDERBY ( 'Calendar'[Year-Quarter], DESC ) )
RETURN
    RANK ( SKIP, _topfive, ORDERBY ( 'Calendar'[Year-Quarter], DESC ) )

Recent 5 quarters sales: = 
VAR _today =
    TODAY ()
VAR _t =
    SUMMARIZE (
        FILTER ( ALL ( 'Calendar' ), 'Calendar'[Date] <= _today ),
        'Calendar'[Year-Quarter]
    )
VAR _topfive =
    WINDOW ( 1, ABS, 5, ABS, _t, ORDERBY ( 'Calendar'[Year-Quarter], DESC ) )
RETURN
    CALCULATE ( [Sales total:], KEEPFILTERS ( _topfive ) )