Calculated column IF statement

[ArslanManzoor]

Hello

Can anyone help with a problem I have in Power BI please?

I have a table - sample below - and I'd like the True/False column to show the text string "TRUE" if the value in 'Days' is 1 or 0. If the value is more than 1 or a negative number, or is blank, it should show "FALSE". To demonstrate the rules, i've shared the sample table below.

I have tried IF statements and SWITCH but can't seem to get it to follow all of the rules above.

[Natallia_23 · Accepted solution]

Hello,

Column = if(Test[Days] in {0,1}, "TRUE", "FALSE")