Nested IF formula or similar

[Kristofferaabo]

Hi, I'm working on a column in powerBI that needs to group my 'Status'. The groups should either be open or closed.

I have following stutus' in my "Status" column: Award, Loss, meeting scheduled, rejected offer, rebid

Following should return "closed": Award, Loss, rejected offer

Following should return "open": meeting scheduled, rebid

Does anybody know how I can make this as a formula to a column, would think its a nsted IF in some way?

Thanks

[BalaVenuGopal · Accepted solution]

Hi @Kristofferaabo ,

once your data is loaded then you create New column as bellow :

Status = IF(table[Status] = "Award" || table[Status] = "Loss" ||  table[Status]  = "rejected offer","Closed","Open")

Please mark as solution if this resove your issue.

[Kristofferaabo]

great stuff, didn't know the " || " ..THANKS