Forum Discussion

UNICODE's avatar
UNICODE
Helper I
3 years ago
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...
  • UNICODE's avatar
    UNICODE
    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