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
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
Hi v-huizhn-msft!
But how to get max date for each Customer number if it have few of them?
Thanks
Kaspars