Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
Hi,
Your question is not clear. Show a dataset and the expected result.
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
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
106 | |
87 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |