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 

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}?