Rank within a group

[Sander1401]

I am totally lost...

I want to compare the most recent date with the second date within a group, but nothing works...
Please help, this is my data, and the rank is my goal:

Code	Date	Rank
2636	01/06/2010	5
2636	20/04/2014	4
2636	01/03/2017	3
2636	30/05/2018	2
2636	30/11/2021	1
7603	01/03/2015	4
7603	10/07/2017	3
7603	29/11/2021	2
7603	30/11/2021	1

[smpa01 · Accepted solution]

@Sander1401  this is the measure to use

Measure = 
VAR _code = MAX(tbl[Code])
RETURN RANKX(FILTER(ALLSELECTED(tbl),tbl[Code]=_code),[_date],,ASC)