Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
8 years ago
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...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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

parry2k's avatar
parry2k
Super User
8 years ago

your column type is List? That function is to find max in a list or use groupby function to get maximum date.