Forum Discussion
Solved
Latest Date Flag Column
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...
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
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