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

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.

MarcelBeug's avatar
MarcelBeug
Community Champion
8 years ago

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])