Forum Discussion
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
any idea how to do this please?
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
1 Reply
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