Getting the latest value on a date

[mlinsin]

I have 3 columns of which 2 are calculated fields
I have the following records

Area(calc) Date Score (calc)
Production 2/2/2025 100
Logistics 2/5/2025 90
Maintenance 2/1/2025 80
Production 2/4/2025 85
Logistics 1/10/2025 70
Maintenance 2/15/2025 92

I want to get ONLY the latest scores for each area, so
Logistics 2/5/2025 90
Production 2/4/2025 85
Maintenance 2/15/2025 92

It seems simple but I can get this to work

I used maxover and also filters with top / bottom but no success
can someone help?
thanks!

[Deep]

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

[Giridhar.Prabhu]

Hi @mlinsin

While I don’t use it for this purpose; but you can use the same technique here. Steps below

a. Create calculated field to get the Max Date

b. Create a Boolean Flag calculated field for filtering

c. Filter visual using the Boolean Flag

Regards,
Giri