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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
PK316
New Member

How to return the actual value found in a text search

Hi,

 

I have a column A that contains sentences. In column B, I want to search for particular words in Column A. if a particular word is found in Column A, then I want to return the value that was found, rather than a true/ false value, or the starting position number of the word found. I have looked at text.contains in the M language, and in DAX, have looked at SEARCH, RELATED, MID etc. but nothing seems to give me what I wanted.

 

Any help would be appreciated.

 

Thanks,

Patricia

3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @PK316,

 

By my test, you could create a calculated column with the formula below.

 

check =
IF ( FIND ( "you", 'Sheet14'[Text],, 0 ) <> 0, "you", BLANK () )

Then you could get the output below.

 

Capture.PNG

 

Hope it can help you!

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for this response. The problem is that I have a list of search terms that I want to use, and dependent on the search term found, the value for to be returned if true will be different thus needs to be read from a list also and not hardcoded.

Drors
Resolver III
Resolver III

The search formula work fine to me:

1.PNG

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.