Forum Discussion

FILIPKACZMAR's avatar
FILIPKACZMAR
Icon for Advocate I rankAdvocate I
3 years ago
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 ( ...
DAX
Help me please
If function
  • johnt75's avatar
    johnt75
    3 years ago

    try

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

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

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

try

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

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