Forum Discussion
Veternus
2 years agoFrequent Visitor
Analysis - Multiple Match
Hello guys! I feel like this should have some obvious solution, however I'm not seeing it and o I decided to ask you for help. I need to do an analysis of questions asked by our customers a...
- 2 years ago
Hi Veternus
You need to make some "ETL" to prepare the table for analysis with PQ.In the first step, clean unnecessary quotation marks at the columns of products and answers :
in the next step split these columns into rows :
Then you will get a clean vertical table that you can work with and create desired and other visuals:
The pbix is attached with all the steps of PQ recorded so you can follow them
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Veternus
2 years agoFrequent Visitor
Thank you for your insight