Forum Discussion
FILIPKACZMAR
Advocate I
Advocate IProblems 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
- FILIPKACZMAR
Thank you!
johnt75Super User
try
'SQA list 2022'[Status] IN { "Completed", "Waived", "Cancelled", "Missed" }that will return true if the status is one of those values, false otherwise
