Get minimum year when status = Open

Question

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

kt_bsmart2gethe · Accepted Answer

Hi&nbsp;ScottBrown&nbsp;,
&nbsp;
List.Min(
    Table.SelectRows(
          #"Changed Type",
          each
              [Status] = "Open
    )[Year]]
)
&nbsp;
Regards
KT

Forum Discussion

Get minimum year when status = Open

2 Replies

Related content

1st year Status

Return minimum selected year of slicer

Track NPS Status within Years.

minimum F capacity for embedding

COUNT STATUS CHANGE YEAR-OVER-YEAR