Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
In power query I have a text column with phrases. I want to categorize the phrases by one or more keywords found in the text. The keywords are defined in another table.
I would like the found keywords to be added as a table/list in a new column. The reason I want a table returned is, that I intend to expand this. same as https://community.fabric.microsoft.com/t5/Desktop/Power-query-Add-column-with-list-of-keywords-found....
I am using a function in m code(photo attached) to extract all rows that match the words from the list.
ID | text | keywords to be searched for | table to be returned |
111 | standard price for the product | standard price | standard price |
112 | standard for the product | standard | standard |
113 | price for the product | price | price |
I have an issue with this solution
When i expand the table if there is a text that contains 'price', I can see also the rows with 'standard price'.
This is not what I want. 'Price' and 'Standard price' should be separate categories( the one shouldnt be included in the other). In other words , if the text contains price w/o th word standard, this shouldnt be included in standard price.
Thank you.
Solved! Go to Solution.
Hi @pbi_data ,
Please try:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi @pbi_data ,
Please try:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum