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.
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
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"
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
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |