Forum Discussion
Power Query: List.Max doesn't work on Date
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
Whats the context of the power query line of code? Are you passing a column or list type to the function? The error message reads like you have passed a since value of type Date.
So I added a column with this 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,
AngeliaHi v-huizhn-msft!
But how to get max date for each Customer number if it have few of them?
Thanks
Kaspars
So when you look at the actual code in the Advanced Editor, does this come after an 'each' statement? If so, you are passing a single value into that statement.
The column name must be preceded by the table name, which can be either the name of another query or the name of another step in the current query.
=List.Max(Table[Date Column])
