Forum Discussion

akhaliq7's avatar
akhaliq7
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Switch statement when multiple conditions are applied

Hi I want to use a switch statement whereby I use two fields for the condition e.g.   I want the condition to be: case 1: product availability: Y product stock: 1-10 -> low stock   case 2: pr...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi akhaliq7 .

    You can create a measure like;
    Availability=
    var a=SELECTEDVALUE(Table[Product Stock])
    var b=SELECTEDVALUE(Table[Product Availibility)
    return
    SWITCH(
    TRUE(),a="1-10" && b="Y","Low stock",
    a="11-50" && b="Y" ,"Mid Level stock",
    a="50-100" && b="Y" ,"High Level stock").


    Let me know if that works.

    Thanks,
    Sanket


    If this post helps, then mark it as 'Accept as Solution' and give it a thumbs up.





Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi akhaliq7 .

You can create a measure like;
Availability=
var a=SELECTEDVALUE(Table[Product Stock])
var b=SELECTEDVALUE(Table[Product Availibility)
return
SWITCH(
TRUE(),a="1-10" && b="Y","Low stock",
a="11-50" && b="Y" ,"Mid Level stock",
a="50-100" && b="Y" ,"High Level stock").


Let me know if that works.

Thanks,
Sanket


If this post helps, then mark it as 'Accept as Solution' and give it a thumbs up.





akhaliq7's avatar
akhaliq7
Icon for Post Prodigy rankPost Prodigy
4 years ago

thanks your solution worked only thing I changed was instead of a="1-10" i did a>=1 && a<= 10 && b="N".