Forum Discussion
Power BI DAX Function 'SWITCH' does not support comparing values of type True/False
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
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
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