Latest Date Flag Column

[M_SBS_6]

Hi, I want to add a custom column in my table within Power Query that will find the max date for each row and return it with a value of "latest date" else "older". 

I have a column call testdate 

any idea how to do this please?

[amitchandak · Accepted solution]

@M_SBS_6 , I Think you want for column

a New column in power query

 if [testdate]  = List.Max(LastStepTableName[testdate]) then  "latest date" else "older"

For List.Max, we need table name, so check what is table name last step example #"Changed Data Type"

Power Query - List.Max and List.MaxN : https://youtu.be/22a8fq2UeBw