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.
Hi guys,
Hope you can help. I am trying to use a switch statement to create categories labeled as "0-7 days" "8-30 days" and"30+ days".
However I keep recieving the following error code:
"DAX Comparison operations do not support comparing values of type true/false with values of type integer. Consider using the VALUE or FORMAT function to convert one of the values".
I have attached a screenshot of the DAX and error message below:
I have checked the 'Days' Data type and it is formatted as a number. Any idea where I am going wrong and how to fix it?
Thanks in advance!
DRJ.
Solved! Go to Solution.
Hi @DRJ1994 ,
Please try this:-
length of sickness =
SWITCH (
TRUE (),
'Sheet1 (2)'[Days] <= 7, "0-7 days",
'Sheet1 (2)'[Days] >= 8
&& 'Sheet1 (2)'[Days] <= 30, "8-30 days",
'Sheet1 (2)'[Days] > 30, "30+ days"
)
BR,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @DRJ1994 ,
Please try this:-
length of sickness =
SWITCH (
TRUE (),
'Sheet1 (2)'[Days] <= 7, "0-7 days",
'Sheet1 (2)'[Days] >= 8
&& 'Sheet1 (2)'[Days] <= 30, "8-30 days",
'Sheet1 (2)'[Days] > 30, "30+ days"
)
BR,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Thank you so much! That helped and solved my issue!
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |