The straight forward analogon to the suggested chart expressions would be a GROUP BY clause with the same functions:
Maxstring(StartDate) as StartDate,
FirstSortedValue(StatusReason, -StartDate) as StatusReason
GROUP BY ID;
Sunni, if your data shows more than one record with the same max StartDate, the FirstSortedValue() either needs the DISTINCT qualifier or you need to add a small value to the sort weight for tie breaking.