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 ("...
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]
)