Text Contains

[EugeniaBochko]

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!

[parry2k · Accepted solution]

@EugeniaBochko 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.

[EugeniaBochko]

Thank you so much! It works properly.

[Greg_Deckler]

@EugeniaBochko Try:

Column =
  IF(
    CONTAINSSTRING([Column], "Text 1") &&
    CONTAINSSTRING([Column], "Text 2") &&
    CONTAINSSTRING([Column], "Text 3"),
    "New Text",
    [Column]
  )