Forum Discussion

Ning_pbi's avatar
Ning_pbi
Regular Visitor
6 years ago

SWITCH

I tried to use SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>]) to fulfill the following logic, but failed.

 

case

when <expression> = <value1> then <result1>

when <expression> = <value2> then <result2>

....

else <expression>

 

1 Reply

  • Ning_pbi's avatar
    Ning_pbi
    Regular Visitor

    problem solved.  the dax works, I noticed that I did not clear the filters. 

    Thank you.