Forum Discussion
Solved
Power Query: List.Max doesn't work on Date
Hi, Need some help. Supposedly List.Max should work on Dates right? Like List.Max([Date Column]). I have a column of Date type and I tried to Add Column with the formula List.Max([Date Column...
Hi ovetteabejuela,
As I tested, you need to create the date column as a list, then use it in List.Max(). I have the following sample table.2. Create a custom column using the formula.
=List.Max(#"Changed Type"[Date])
3. You will get the expected result as follows.
Best Regards,
Angelia
Old thread, but this is/was available on the Ribbon also: Transform tab > Date & Time Column section > Date > Latest
It generates the same M as in this thread:
= List.Max(Source[Date])
Thanks for answer! Probably my question was not fully described... What I want to get is MAX DATE for particular customer number and have it sorted from list.
Example:
customer date 1 18.06.2019 1 19.06.2019 1 20.06.2019 2 18.06.2019 2 19.06.2019 3 20.06.2019 Thanks!
