Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Text Contains

Hello everyone! Please advise how to implement the PBI formula like this:   IF TEXT CONTAINS ("Column with text", "Text 1") AND TEXT CONTAINS ("Column with text", "Text 2") AND TEXT CONTAINS ("...
Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    3 years ago

    Anonymous if you want to use DAX option you can add column using following expression:

     

     

    New Column = 
IF ( 
   CONTAINSSTRING ( Table[Column], "SearchText1" ) &&
   CONTAINSSTRING ( Table[Column], "SearchText2" ) &&
   CONTAINSSTRING ( Table[Column], "SearchText3" ), "New Text", "Else Text"
)

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to 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.

     

     

     

parry2k's avatar
parry2k
Super User
3 years ago

Anonymous if you want to use DAX option you can add column using following expression:

 

 

New Column = 
IF ( 
   CONTAINSSTRING ( Table[Column], "SearchText1" ) &&
   CONTAINSSTRING ( Table[Column], "SearchText2" ) &&
   CONTAINSSTRING ( Table[Column], "SearchText3" ), "New Text", "Else Text"
)

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to 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
    3 years ago

    Thank you so much! It works properly.