finding a certain text string using switch

[salman_ali]

Hi team,

looking for some help

i am using switch(TRUE) for various if statements and i want one more but not sure how to add it

I want to see that if a column Ordersleft[ordertext] has this text in it "order created by a Sensor", then i want output to say "order created by sensor maintenance" and i don't want an else statement after that.

can anyone help me with it 

[v-alq-msft · Accepted solution]

Hi, @salman_ali 

Based on your description, I created data to reproduce your scenario.

Ordersleft:

You may create a calculated column which display "order created by sensor maintenance" when Ordersleft[ordertext] has this text in it "order created by a Sensor" and 'ID' is greater than or equal to 2.

Result = 
SWITCH(
    TRUE(),
    Ordersleft[ID]>=2,
    IF(
        CONTAINSSTRINGEXACT(Ordersleft[ordertext],"order created by a Sensor"),
        "order created by sensor maintenance"
    ),
    "ID is less than 2"
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@salman_ali you can have nested switch of use if

Test = 
SWITCH ( TRUE(),
  Table[A] = "ABC", "ABC123",
  Table[A] = "XYZ", IF ( Table[C] = "123", "xxx", "YYY" )
)

or

Test = 
SWITCH ( TRUE(),
  Table[A] = "ABC", "ABC123",
  Table[A] = "XYZ", SWITCH ( TRUE(),  Table[C] = "123", "xxx", "YYY" )
)

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[salman_ali]

this is probably a better tool, but i used search to create a new column and printer "Sensor order" when the new column was <> blank()