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...
Hi Anonymous
It could be that the actual values may be exactly equal to the condition.
If you have used precision to cut the source data to 2 decimal points then you may get result like this.
To overcome this, change the precision of the field in the source data itself by going to "Transform Data" and Transform.
Hope this helps!
If I answered your question then pls mark my post as "Accept it as the solution" and a kudo would be appreciated.