Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to convert this to numbers, but getting the message:
"The 'SWITCH' function does not support comparison of values of type True/False with values of type Number. Consider using the VALUE or FORMAT function to convert one of the values."
Please help
Solved! Go to Solution.
Why are you using a comma separator in one part of your calculation, but a decimal separator in another?
If your native format is to display '0.001' as '0,001', then the DAX argument separators should be ' ; ' (semi colon) .
Option 1 = native decimal is comma:
_calculation >= 0,0005 && _calculation < 0,001; 0,005;
Option 2 = native decimal is decimal:
_calculation >= 0.0005 && _calculation < 0.001, 0.005,
Pete
Proud to be a Datanaut!
Hi @MaleneL ,
I think the issue is here:
These conditions would need to be written like this:
_calculation >= 0.0005 && _calculation < 0.001, 0.005,
_calculation >= 0.001 && _calculation < 0.002, 0.001,
... etc
Pete
Proud to be a Datanaut!
no that's not it :O)
Still same issue:
"The 'SWITCH' function does not support comparison of values of type True/False with values of type Number. Consider using the VALUE or FORMAT function to convert one of the values."
Why are you using a comma separator in one part of your calculation, but a decimal separator in another?
If your native format is to display '0.001' as '0,001', then the DAX argument separators should be ' ; ' (semi colon) .
Option 1 = native decimal is comma:
_calculation >= 0,0005 && _calculation < 0,001; 0,005;
Option 2 = native decimal is decimal:
_calculation >= 0.0005 && _calculation < 0.001, 0.005,
Pete
Proud to be a Datanaut!