Forum Discussion

Helper II

3 years ago

Solved

Get minimum year when status = Open

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.

3 years ago

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

Regards

Impactful Individual

3 years ago

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

Regards