Find the Latest Value

Hey,

i created a calculated column using this DAX statement:

Is Latest = 
var currentIDNo = 'Table1'[ID No]
var latestDate = 
CALCULATE(
    MAX('Table1'[Recruitment Stage Date])
    ,FILTER(ALL('Table1')
        ,'Table1'[ID No] = currentIDNo
    )
)
return
IF('Table1'[Recruitment Stage Date] = latestDate, TRUE(), FALSE()) 

Here is a screenshot of the result (my assumptuon: the Recruitment Stage Date is of data type datetime or date). Please be aware that my table shows other dates, this is due some date formatting issues :-) but nevertheless I can use the statement on your table:

This column can now be used to filter the table.

Hopefully this is what you are looking for.

Regards

Tom