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

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
8 years ago

So I added a column with this formula:

 

=List.Max([Date Column])

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
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

  • KasparsT's avatar
    KasparsT
    Regular Visitor
    7 years ago

    Hi v-huizhn-msft!

    But how to get max date for each Customer number if it have few of them?

    Thanks 

     

    Kaspars

  • StephenF's avatar
    StephenF
    Responsive Resident
    6 years ago

    How do i do this with an Column of type Int? There is no such thing as a list item in the dropdown i can transform this too.