Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
wangjian
Microsoft Employee
Microsoft Employee

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 listed in the table). In my case the latest date would be 11/18/2020. However it shows me the latest date is 11/16/2020.  I spend some time to debug but could not figure it out. 

I have the partitionKey which is the date, I create  "Date" column which copied the data from PartitionKey. And I change the type of "Date" column to "Datetime" type. 

Then I try to create a new column named "isLatestDate" which will use the function = List.Max(#"Changed Type1"[Date]).  Since List.Max only accept list type of data.

 

However the results is not the one I expected.

 

Thanks for your help.

wangjian_1-1605770194418.png

 

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

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.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

4 REPLIES 4
wangjian
Microsoft Employee
Microsoft Employee

Thank you Phillips. After couple of sorting and refreshing. it works for me now. Very appreciate.

PhilipTreacy
Super User
Super User

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.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


The problem arises when dates are in different formats. 

wangjian
Microsoft Employee
Microsoft Employee

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.

wangjian_0-1605770688649.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors