Forum Discussion
How do you treat questionnaires in Power BI
Dear all, Let's say you have a questionnaire and need to make multiple viuals with different operations. I can think of 2 ways to structure my "Answers" table : 1 - Lots of rows, minimal...
Hi QuangMC ,
If you have access to Power Query, then the calculations for the first table won't be too complicated. For example, you mentioned "Count the distinct number of clients that have answered "Lorem" in question 1, AND "Ispum" in question 2 ?"
We can use this simple method in Power Query to calculate this question:
The final output is as below:
Only further processing is needed to remove the null values, and it is also very clear to see how each question was answered.
Or you can use Group By:
The final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.