Forum Discussion
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 ("Column with text", "Text 3")
THEN "New Text"
I added an example How it looks in Google Data Studio , I need the same in PBI.
I’d really appreciate your help!
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.
3 Replies
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 Try:
Column = IF( CONTAINSSTRING([Column], "Text 1") && CONTAINSSTRING([Column], "Text 2") && CONTAINSSTRING([Column], "Text 3"), "New Text", [Column] )
