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 There Please can someone advise me how I could create a new table (TABLE02) in my data model which is sourced by transposing some element of my current table (TABLE01). So, in my new table (TABLE02) I want to have some Rows transposed into columns whilst remaining Rows remain as rows (so the data duplicates). Below is an example of what I am trying to achieve;
Solved! Go to Solution.
Hi @ruby18,
You can open Query Editor, select these columns: Question01, Question02, Question03, then select Unpivot Columns.
Best Regards,
Qiuyun Yu
Hi @ruby18,
You can open Query Editor, select these columns: Question01, Question02, Question03, then select Unpivot Columns.
Best Regards,
Qiuyun Yu
Life saver!
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |