Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
my columns that equal true/false are data type true/false and my number columns are data tpe text.
how do I check which is string and non-string?
hi, @yaya1974
use switch() function instead of IF.
like
bucket =
switch(true(),
'Open Sales 55 7 15 3'[Over 15 Days]=true,"over 15",
'Open Sales 55 7 15 3'[6 to 15 Days]=true,"6 to 15 days past due",
'Open Sales 55 7 15 3'[0 to 5 Days]=true,"1 to 5 days past due",
and continue ........)
Hi. I actually was just trying that. it seems to work, but got error now that states:
DAX comparison operations do not support comparing values of type True/False with value of type Text. Considering using VALUE or FORMAT function to convert one of the values.
Have any suggestions?
Thanks so much!!
Hi, @yaya1974
One of your column is type string and you compare it with non-string type column. So these problems occur so check it
my columns that equal true/false are data type true/false and my number columns are data tpe text.
how do I check which is string and non-string?
User | Count |
---|---|
134 | |
71 | |
70 | |
54 | |
52 |
User | Count |
---|---|
205 | |
95 | |
63 | |
61 | |
54 |