Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
eliasayyy
Memorable Member
Memorable Member

How to extract Text auatomaticaly in power query

Hello everyone i have a dataset from data.world for iphone xr reviews and i was curious when i saw a dashboard that made this " top 5 negative words ":

photo_2023-03-07_14-10-47.jpg


the column provided are not limited to the screenshot below :

annonymous1999_0-1678191008239.png

 


so how can i extract like what he did from the column review_text?

i dont want to use ifs since dataset is large and i want it to be as if there are millions of rows that are unique where i cant use ifs and else ifs

5 REPLIES 5
tamerj1
Super User
Super User

@eliasayyy 

What exactly are you trying to extract? Please provide some examples 

Hello @tamerj1 , as yoi can see from first picture, the person was able to extract "no fongerprint scanner"

"Battery life isnt good" 

 

All from the review_text column . Given reviews arent written qll the same and some people might make grammar mistakes or write it differently for example someone writes "bad battery life" or someone else wrotes " "battery life isnt good" or someone saying "the battery can be better" all should fall under 1 category which is "bad battery life"

@eliasayyy 

If you have a table of all these categories then we can use dax to return the best match (and no less than a certain limit let's say 50% or 60% match) 

however, this won't be easy and is extremely heavy calculation. 

@tamerj1 oh can you please provide with some of them or a page to refer to to learn it? It would be much appreciated for this will help me in future projects

@eliasayyy 
Please check your private messages

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.