Forum Discussion

nirvana_moksh's avatar
nirvana_moksh
Impactful Individual
8 years ago
Solved

DAX Involving TRUE/FALSE Column

Hello Community,   How do you deal with writing a DAX Statement that invloves a column that is of data type TRUE/FALSE without converting it to text and making it to work?     Thank You
Need Help
Show and Tell
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi nirvana_moksh,

     

    Maybe you need something similar to below. Here [Column1] comtains 'TRUE/FALSE' data type values.

    New column = 
IF ( Table[Column1] = TRUE (), 1, 0 )

    Regards,

    Yuliana Gu

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Your question is not clear.  Show a dataset and the expected result.

nirvana_moksh's avatar
nirvana_moksh
Impactful Individual
8 years ago

So I was using a calculated IF statement and it was using a column which was 'TRUE/FALSE' data type and for some reason the DAX did not recognize that and I had to convert that column to Text for it to work

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi nirvana_moksh,

     

    Maybe you need something similar to below. Here [Column1] comtains 'TRUE/FALSE' data type values.

    New column = 
IF ( Table[Column1] = TRUE (), 1, 0 )

    Regards,

    Yuliana Gu

     

    • NKL's avatar
      NKL
      Frequent Visitor
      3 years ago

      This actually is not allowed in my case because a single value for the TRUE/FALSE data type field "Active Schedule" cannot be determined

      Can you figure out why it is not working?

       

      • Smamwise's avatar
        Smamwise
        Frequent Visitor
        2 years ago

        You might be trying to create a measure. Try a calculated column instead.