Convert Integer to Logical

[jaykilleen]

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

[v-chuncz-msft]

@jaykilleen,

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

[Anonymous · Accepted solution]

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.