Solved: Convert Integer to Logical

jaykilleen · ‎06-13-2017

PowerBI seems to have a hard time converting "1" and "0" to TRUE and FALSE.

Is the best way here to convert to Whole Number first then add another step to convert to True/False??

Expression.Error: We couldn't convert to Logical.
Details:
    1

Anonymous · ‎06-13-2017

Either through Power Query or DAX i'd make another column. The formula would just be [Value] = 1. That way if [Value] is 0, you will get a false, and if it is 1 you will get a true.

View solution in original post

v-chuncz-msft · ‎06-14-2017

@jaykilleen,

I agree with the comment above. You could also nest type transformation in one step by using Advanced Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎06-13-2017

Either through Power Query or DAX i'd make another column. The formula would just be [Value] = 1. That way if [Value] is 0, you will get a false, and if it is 1 you will get a true.