Problems with if funciotn

[FILIPKACZMAR]

Hello everyone!

I want to make a checklist in my Power BI dashboard. I have got column called status in my data. I want to sort it in another column by "True" and "False". 
I wrote code: 

if ( 'SQA list 2022'[Status] = "Completed, Waived, Cancelled, Missed", True(), False())
But it is giving me back only False values.

Can you help me? Thank you

[FILIPKACZMAR]

Thank you!

[johnt75 · Accepted solution]

try

'SQA list 2022'[Status] IN { "Completed", "Waived", "Cancelled", "Missed" }

that will return true if the status is one of those values, false otherwise