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?