Forum Discussion
powerbidev123
Solution Sage
Solution SageConvert boolean value using Value function
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 s...
Hi johnt75 , I have corrected it to &&, still getting the same error
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().
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
Super User
Super UserYou've got a single &, that's the concatenation operator. You need &&, which is logical AND.