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 clumn with Departments. What I need to get is the third columns with dates rank within departments as presented below on the screen:

 

The column 'Rank column that I want to achieve' is my goal. The 'Sorting_rank' is what I did but this is not exacly what I want,

Please help with fixing my DAX.

 

Attaching my pbix and data sourc files:

Source data file

pbix file

 

thanks in advance for help. 

 

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
)

1 Reply

  • 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
)