Forum Discussion

Colinu's avatar
Colinu
Helper I
8 years ago
Solved

Formula for Number to Text

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

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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