Forum Discussion
UNICODE
3 years agoHelper I
SWITCH function for changing UNICODE values not working correctly.
Hello Everyone, I have one that has stumped me. I have written a switch statement that will change the UNICODE values of in a calculated column. I would like it to display the LAST value in a car...
- 3 years ago
This appears to be working now. I did two things.
1. I moved it to a measure.
2. I changed the code, adding the MAX function.FCMES = VAR WUCL=UNICHAR(128531) VAR UCL=UNICHAR(128530) VAR sigma=UNICHAR(128532) VAR good=UNICHAR(128513) VAR UCLV=0.875 VAR WUCLV=0.625 VAR sigmaV=0.5 Var goodV=0.3 VAR SWITCHER= Switch(TRUE(), Max('Example Data'[Value])>=UCLV,UCL, MAX('Example Data'[Value])>=WUCLV,WUCL, Max('Example Data'[Value])>=sigmaV,sigma,good) Return SWITCHER
UNICODE
3 years agoHelper I
Moved this to a reply