Forum Discussion
If Condition for Text not Working
Hey, I have a [Status] Column where I'm trying to consolidate the 7 different types into either Open or Closed. I've tried multiple IF statements, but PBI doesn't seem to be reading my data correctly...
I would try to accomplish this with a measure using a switch statement such as:
status = switch([status],
Retired, "Closed"
Submission Declined, "Closed"
Closed with Feedback, "Closed"
assigned,"Open"
etc...
)
If you wanted to stick with an IF statement it would have to be nested such as:
IF([status] = "retired","Closed",(IF([status] = "Submission Declined","Closed",(IF([status] ="assigned","open",(IF etc.. )))
but that could get long and messy which is why i recomend the switch statement above