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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.