cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

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.

 

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

Hi @ScottBrown ,

 

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

 

Regards

KT

Thanks @KT_Bsmart2gethe  - this helped a lot.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,180)