Ranking values within groups

[Anonymous]

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. 

[Anonymous · Accepted solution]

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
)