Forum Discussion
Solved
Nested IF formula or similar
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, ...
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.
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.
great stuff, didn't know the " || " ..THANKS