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

     

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.