Formula for Number to Text

[Colinu]

HI All

I have a column that is imported from another APP. The value is is 1 or 0, 1 representing PAss and 0 Fail. 

I tried to use an If statement to convert the the number but DAX don't allow this. 

Can anyone point me in the right direction to convert these from 1 to "Pass" and 0 to "Fail"

 Thanks

[Anonymous · Accepted solution]

Hello,

You can use the Conditional Column in Query editor. for pass and Fail column.

here is the screen shot for your reffrence.

Thanks,

Pankil