More than 1 IF looking at status Column

[dommyw277]

Hi I want to create a column that says if the status column is work in progress or pending then return the word "open" if not then closed ?

Thanks

[Idrissshatila · Accepted solution]

Hello @dommyw277 ,

try the following but use your table name, column name and field values in the measure:

Column = if('YourTableName'[status] IN {"work in progress", "pending"},"open","closed")

[dommyw277]

Amzaing thank you so much 🙂