Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

finding a certain text string using switch

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 

Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    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.

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous 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.⚡

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, Anonymous 

     

    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.