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 th...
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.

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