Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a set of data that looks like the below;
ConfirmationId | Answers.Questions.QuestionName | Answers.TextAnswer |
330478 | BOOKING REQUEST DATE | 17.01.20 |
330478 | CANDIDATE EMAIL (NC) | test@GMAIL.COM |
330478 | INVOICE TO mandatory | CANDIDATE TO POD |
330478 | COST CODE | NA |
330478 | etc.... | etc..... |
I want the data to look like this below;
ConfirmationId | BOOKING REQUEST DATE | CANDIDATE EMAIL (NC) | INVOICE TO mandatory | COST CODE | etc.... |
330478 | 17.01.20 | test@GMAIL.COM | CANDIDATE TO POD | NA | etc.... |
I need this to work for as many column names that are listed in the first table (which is more than what I've shown).
Solved! Go to Solution.
Fortunately for you, this will still work, even on text 🙂
Just select your second and third column. Then do pivot, in advanced options choose MAX instead of COUNT and in your "values" column use your Answers.textanswer column.
Tadaaa 🙂
Jaap
Refer, this can help
https://radacad.com/pivot-and-unpivot-with-power-bi
Thanks for the quick reply. I did try to pivot the column but I don't have numbers in the values column it is text data.
Fortunately for you, this will still work, even on text 🙂
Just select your second and third column. Then do pivot, in advanced options choose MAX instead of COUNT and in your "values" column use your Answers.textanswer column.
Tadaaa 🙂
Jaap
Perfect!
Thankyou all.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |