extract certain text from columns

[AbbasG]

Hi All,

I have a column that contains comments posted by different groups of people. Below image for reference.

I want to extract specific words from the comments, and then use that extracted columns as a  category filter.

[AbbasG]

@menglaro78 Hi thanks for the reply, it works but a bit difficult to set-up instead I managed it in SQL database through query.

[menglaro78 · Accepted solution]

HI @AbbasG ,

I suggest two approaches.

1) In Power Query, you can use Cognitive Services to automatically extract keywords (Tutorial: Integrate Power BI with key phrase extraction - Azure Cognitive Services | Microsoft Learn)

2) Use Power Query function like this example (Searching for Text Strings in Power Query • My Online Training Hub)

Marco

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!