Forum Discussion
Solved
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...
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 , You need to create this face change measure on the measure, I doubt you are creating a column based on column
example
Switch(TRUE(),
sum('Example Data'[Value]) >=UCLV,UCL,
sum('Example Data'[Value])>=WUCLV,WUCL,
sum('Example Data'[Value])>=sigmaV,sigma,good)
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