Rankx with duplicate rows

[DimD]

Hello dear community,

I have a problem with the ranking.
I have a table with duplicate data,
People who have made interventions per day.
I try to have a ranking to be able to make other measurements.
I tried the expression rankx, as well as other articles from here including this one which I thought would help me but as you see it is not the case.

I should have seen the closest date to 01/01/2022 in number 1 and not 16...

You will find a sample of data below.

Can you help me?

Thanks

Sample+sources  

[DimD]

Hello, 

Little update. 

Here is the expected result : 

I try a new link but its not working : Power BI – Handling Duplicate Rankings using RANKX DAX Function | LinkedIn

and this one : Solved: Rankx = struggling with duplicates values - Microsoft Power BI Community

Perhaps I make a mistake... 

[DimD · Accepted solution]

I found the solution based on the article :

Power BI – Handling Duplicate Rankings Using the R... - Microsoft Power BI Community
First of all, I had too many duplicates that were polluting the results.
So I took the table and made a reference.
Then I removed the nulls that were creating a lot of duplicates, I applied the filters for the ranking directly on the table.
Then I created an index

After that I created a column :

Rank = rankx(Filter(table,myfield = Earlie(myfield)), date, , ASC, Dense)
Rank corrected = rankx(Filter(table,myfield = Earlier(myfield)),myfield + index/power(10,5)), ,ASC, Dense