Forum Discussion
akhaliq7
Post Prodigy
Post ProdigySwitch 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...
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.
