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.
Thank you Phillips. After couple of sorting and refreshing. it works for me now. Very appreciate.