How to extract Text auatomaticaly in power query

[eliasayyy]

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 ":

 

the column provided are not limited to the screenshot below :

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

[tamerj1]

@eliasayyy 

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

[eliasayyy]

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"

[tamerj1]

@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. 

[eliasayyy]

@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

[tamerj1]

@eliasayyy 
Please check your private messages