Forum Discussion

wangjian's avatar
wangjian
Microsoft Employee
5 years ago
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...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    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.

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    The problem arises when dates are in different formats.