Forum Discussion
Switch statement not working
Perc_display = SWITCH ( TRUE (), '_1'[Value]= 0.0 , "0%", '_1'[Value]= 0.05, "5%", '_1'[Value]= 0.10, "10%", '_1'[Value]= 0.15, "15%", '_1'[Value]= 0.2...
I am still trying to understand why it's happening. however I have found a workaround to display % values.
As a workaround I duplicated the "Value" column , multiplies by 100 and concatenated with "%" symbol. this will be used only for display purpose. In this way I have a column for calculation and other for display.
Best