How to write a DAX using switch clause for different output with different Conditions .

Question

Why this ciondition is not working accordingly?

MomentumActOutput =

SWITCH(TRUE(),ISBLANK([MomentumAct]),BLANK(),

([MomentumAct]>0 && [MomentumAct]<2),UNICHAR(129112),([MomentumAct]=0),UNICHAR(129112),

([MomentumAct]>-2 &&[MomentumAct]<2),UNICHAR(129112),

([MomentumAct] >2),UNICHAR(9650),

([MomentumAct] <-2),UNICHAR(9660),

BLANK()

)

pattemmanohar · Answer

Anonymous&nbsp; It will be helpful if you can post some sample data and expected output.

Forum Discussion