Forum Discussion
Solved
Have issue with M Query List.Max(Date), it did not return the Latest date for me.
Hello, I recently have an issue with List.Max(Date) in the M-Query. I have a table. I want to use M-Query to transform the table and add a new column which contains the Latest date (Latest date...
Hi wangjian
I can't reproduce the problem with my sample data copied from yours, this works correctly
= Table.AddColumn(#"Changed Type", "IsLatestDate", each List.Max(#"Changed Type"[Date]))and gives Nov 18th as the latest date.
If you sort the Date column in Descendingorder what do you get?
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Btw, I also try this , since the "Date" Column has time. I change it to "Show date only" which is the new column "Date.1" and try to get the latest date by using List.Max() function based on the "Date.1". I still have same issue like the followings, it does not show the latest date.