Forum Discussion

Veternus's avatar
Veternus
Frequent Visitor
2 years ago
Solved

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...
  • Ritaf1983's avatar
    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