Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
EugeniaBochko
Advocate II
Advocate II

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!

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@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 YouTube.gif 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.

 

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

3 REPLIES 3
parry2k
Super User
Super User

@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 YouTube.gif 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.

 

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Thank you so much! It works properly.

Greg_Deckler
Super User
Super User

@EugeniaBochko Try:

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.