Convert boolean value using Value function

[powerbidev123]

Hi Community,

I am getting this error as I am trying create a calculated column and convert Boolean value to string for comparing it with text value in another column.

Below is the sample dataset screenshot

Any help will be appreciated as to how to rectify this error

[johnt75]

You've got a single &, that's the concatenation operator. You need &&, which is logical AND.

[powerbidev123]

Hi @johnt75 , I have corrected it to &&, still getting the same error

[johnt75 · Accepted solution]

If the exception column is a true/false type, which it looks like it is, then I don't think you need the VALUE function. You should just be able to compare the exception column to TRUE().

[powerbidev123]

Thanks @johnt75 , this worked. But still don't know how. Because we didn't convert the Boolean type to text and compared it to text value

[johnt75]

I think its because VALUE expects a text value and you were passing in a boolean. The error message could be phrased better.