Finding Earliest Information from a Duplicated Result

[Anonymous]

Hi everybody,

Got a situation where I would like to flag the lastest information from a duplicated or triplicated result (the result is a unic reference number so, its sure that the result is right but want to keep just the latest one) where the date would answer wich is the most recent added to the table

Basically, I want to creat this LATEST column and flag the latest one base on the column NAME + LAST REFRESH

Name	Age	Last refresh	LATEST
John	25	01/01/2020	-
Tom	37	01/01/2021	X
John	26	01/01/2021	X

[amitchandak · Accepted solution]

@Anonymous ,  Try new column

Latest =

var _max = maxx(filter(Table, [Name] = earlier([Name]) ), [LAST REFRESH])
return
if([LAST REFRESH] = _max , "X", blank())

[Anonymous]

Jesus Christ, worked spotless. Thank you so much @amitchandak