Forum Discussion

TimmK's avatar
TimmK
Helper IV
2 years ago
Solved

Group By Second Laste Date

In Power Query I want to use Group By, but not get the rows with MAX, but second last MAX value.

 

How can I accomplish this?

Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

    TimmK (upd) make your list distinct, sort descending order and take 2nd item from the list as list_name{1}?

  • slorin's avatar
    slorin
    2 years ago

    Hi,

    anothere solution

    List.Max(List.Difference([Your_Column], {List.Max([Your_Column])}))

    Stéphane 

2 Replies

  • AlienSx's avatar
    AlienSx
    Super User
    2 years ago

    TimmK (upd) make your list distinct, sort descending order and take 2nd item from the list as list_name{1}?

  • slorin's avatar
    slorin
    Super User
    2 years ago

    Hi,

    anothere solution

    List.Max(List.Difference([Your_Column], {List.Max([Your_Column])}))

    Stéphane