cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Resolver III
Resolver III

Re: How to return the actual value found in a text search

The search formula work fine to me:

1.PNG

Highlighted
Resident Rockstar
Resident Rockstar

Re: How to return the actual value found in a text search

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.
Highlighted
New Member

Re: How to return the actual value found in a text search

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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors