Find KEYWORDS from strings EASILY using this trick // Beginners Guide to Power BI in 2022

[@cecewang70]

that's exactly what i need for my work! thank you !

[@lijunchen]

Great video. This is a clear way to do cartesian matching.

[@SolutionsAbroad]

Thanks for watching!

[@gintomino4136]

This is very helpful!!! I can now use this in certain dashboards. Thanks!! U're the best.

[@jrobinson8898]

Very Helpful!! Thank you!!

[@fpoester]

I have a question. If I have a larger dataset, let`s say 10k responses, and lets say 10 keywords, the comparison table out of a sudden will jump from 10k to 100k. This can get nasty for performance quite fast. Can I somehow just relate both tables without unpivoting the keywords? I hope I was clear with the question, thank you for the very interesting material.

[@manognas455]

Did you figure out how to do it?

[@mominfauzan8279]

Thank you for making this channel, it's very Useful

[@Nura853]

Thank you for the great video!

[@SolutionsAbroad]

No worries!

[@rohanthawale7889]

Hie i have a question on 5:00 where did you clicked to edit ? i did not found it

[@johnnyhernandez8605]

Great video! I am wondering if you know of a way to make this an exact match?

[@luiseachflynn7098]

Very helpful thanks so much! Quick question: one of my keywords is "Dust" and the query is matching records containing the word "Industry", any tips on how to address this? Thanks again :)

[@marjorieherrera3031]

Same question here!

[@lijunchen]

How about adding a space before and/or after the keyword?

[@fpoester]

I had a similar problem and added a space before. As long as the word is not the first of the sentence, it should work.

[@redsectionXD]

Life saver

[@cecewang70]

i did the same for my work. But it's not counting correctly. for example, it counts much 18 "1"s while there are only 2 "1". it counts 36 while there are 6 "1". Any idea what is wrong? Thank you!

[@rajendratiwari5321]

I tried this method for a large dataset it's generating too many duplicate values and while sorting it gives me error as "can't convert the value # (2022,12,02) to date" Please help

[@zoomingby]

Lol, you say "without further ado, let's get started." THEN you introduce yourself and do more marketing of your channel, etc. I'm not sure you know what "without further ado" means.