Forum Discussion
Solved
Problems with if funciotn
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
But it is giving me back only False values.
Can you help me? Thank you
try
'SQA list 2022'[Status] IN { "Completed", "Waived", "Cancelled", "Missed" }that will return true if the status is one of those values, false otherwise
2 Replies
try
'SQA list 2022'[Status] IN { "Completed", "Waived", "Cancelled", "Missed" }that will return true if the status is one of those values, false otherwise
Thank you!
