cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Tanusha Frequent Visitor
Frequent Visitor

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

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()

)

1 REPLY 1
Super User
Super User

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

@Tanusha  It will be helpful if you can post some sample data and expected output.



Did I answer your question? Like and Mark my post as a solution !

Proud to be a Datanaut !