Table filter to only display most recent duplicate value

Our Goal: To create a filtered table view which only displays unique “product” values. When multiple “product” values exist, only display the record which contains the most recent date/time in column “created on” row.

In the example below, the filtered table view will only display the bottom three records since the first instance of apple in record one will be filtered out due to the date/time in record 4 being most recent.

Product Quantity Created on
Apple 10 12/16/2020 11:50:28 AM
Orange 20 12/16/2020 11:50:42 AM
Grapes 15 12/16/2020 11:50:58 AM
Apple 5 12/16/2020 11:51:08 AM

Thanks in advance and I appreciate this community!

Hi @Scott_Hill,

you might add an additional column - such as Latest - that shows if that row is the latest for that product with the following formula:

thisTable.Filter(Product=thisRow.Product).[Created On].Max() = thisRow.[Created On]

Then, you filter the table by Latest (=true) column.

Please, do let me know if it’s clear and/or you need additional explanations.
Cheers

4 Likes

@Federico_Stefanato

That is exactly what I’m looking for! Thank you for your help!

I appreciate you and everyone that took the time to review this topic!

1 Like