Forum Discussion
Analysis - Multiple Match
- 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
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