Forum Discussion

Sandeep13's avatar
Sandeep13
Helper III
3 years ago

Rank function Based on ReportedDate like YYYYMM

Hi All,   I have 2 columns reporting_mth and Amount, I want to create rank based on reporting_mth and sort data based on amount.   Now If you see i have 202203 and 202212 in my data. I am expecti...
Need Help
Ahmedx's avatar
Ahmedx
Super User
3 years ago
Order = 
VAR _t = LEFT( MAX( [reporting_mth],4))
RETURN 
    RANKX(
         FILTER(ALL('Table'), 
          LEFT('Table'[reporting_mth],4)=_t),
            [reporting_mth],,DESC)