get the last date from a table

[RimDataAnalyst]

Good morning ,
I have a table that contains ICAO , input date , achievement
I want for each ICAO to retrieve the last achievement that corresponds to the most recent date.
I want to get this last achievement for each ICAO, I tried the max ( input date ) and FirstSortedValue([Input Date], ICAO) the first one does not give what I want since in the group by I have to put ICAO and achievement and the second generation generates an error

[BrunPierre]

Hi, as below.

Dimension: ICAO 

Expression: FirstSortedValue(achievement,-[input date])

[RimDataAnalyst]

i tried this in the chart and it doesn't work 

[BrunPierre]

Share sample data and your expected results.

[RimDataAnalyst]

i want only the to get the achievement of 05-Jan-23 

[BrunPierre]

Aggr(Max([input date]), ICAO)

[vinieme12]

as below

=max ( TOTAL <ICAO> input date )