Forum Discussion

AbbasG's avatar
AbbasG
Memorable Member
3 years ago
Solved

extract certain text from columns

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 co...
Need Help
menglaro78's avatar
menglaro78
Microsoft Employee
3 years ago

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 !!