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

     

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.