Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Search for distinct keywords in description

Hi there,

Does anyone know how to solve this problem I am having?

I am trying to extract multiple keywords from many line descriptions.

I have one spreadsheet that lists the keywords and another sheet with the raw data.  This includes a column of transactional data with the keywords included in the description depending on the type of transaction.  I wish to then categorise this spend into key buckets.

The formula so far is:


Keyword = CALCULATE (FIRSTNONBLANK(Keywords[Keyword Search],1),FILTER(Keywords,Keywords[Mega Category]= 'AP and CC merged data'[MegaCatFinal] && SEARCH(Keywords[Keyword Search],'AP and CC merged data'[Description],,0)>0))


It seems to work reasonably well at pulling out the keyword however one of the search words is tax and it is pulling up all words that include tax in it (such as taxi).  Does anyone know an expression that would find disctinct words instead of contains the text.


I would greatly appreciate your help,

Thank you!!!

Super User IV
Super User IV

Re: Search for distinct keywords in description



Share a dataset and show your expected result.

Ashish Mathur

Helpful resources

May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.



Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors