Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Ranking values within groups

Hi All,   I need to have a rank of the values in my table as a new column. I have read few topics here but non of the solutions works for my case.    I have a column with Dates and the second clu...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Just found a solution. DAX that does exacly what I wanted is: 

     

    Correct_Rank = RANKX (
    FILTER (
        'Sheet1';
        Sheet1[Department] = EARLIER ( Sheet1[Department] )
    );
    Sheet1[Date];
    ; // leave value argument blank
    ASC
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Just found a solution. DAX that does exacly what I wanted is: 

 

Correct_Rank = RANKX (
    FILTER (
        'Sheet1';
        Sheet1[Department] = EARLIER ( Sheet1[Department] )
    );
    Sheet1[Date];
    ; // leave value argument blank
    ASC
)