Get minimum year when status = Open

[ScottBrown]

I am trying to get the result of 2022 in the calculated column, the minimal year where status = open.   I am getting stuck on this formula.

[KT_Bsmart2gethe · Accepted solution]

Hi @ScottBrown ,

List.Min(
    Table.SelectRows(
          #"Changed Type",
          each
              [Status] = "Open
    )[Year]]
)

Regards

KT

[ScottBrown]

Thanks @KT_Bsmart2gethe  - this helped a lot.