Hello Mlinsi,
Have you tried considering Max() function ?
Please see old post for reference -How can i get latest date in a date column where the data is from 01-01-2022 to 31-01-2022 so here the latest date is 31-01-2022
Hope this helps.
Cheers,
Deep