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 table with different columns
Person / Area 1 / Area2 / Area3
An example could be the following :
Robert / France / UK / France
Jane / Belgium / empty / empty
In order to analyze the survey with area dimension, I have to transform the initial table to :
Index / Person / Area
with my example,
0 / Robert / France
1 / Robert / UK
2 / Robert / France
3 / Jane / Belgium
Index could be important to be sure that I can observe two answers from Robert where area is France.
I hope that someone will be able to help me to realize this transformation to obtain this result.
Solved! Go to Solution.
Hope this helps... All of these screen shots come from the Query Editor in Power BI
Your original data:
Select the 3 Area Columns and choose 'Unpivot Columns' from the Transform tab
Now under 'Add Column' - Add an Index Column (from either 0 or 1 depending on your neeeds.)
Here you go!
Proud to give back to the community!
Thank You!
Hope this helps... All of these screen shots come from the Query Editor in Power BI
Your original data:
Select the 3 Area Columns and choose 'Unpivot Columns' from the Transform tab
Now under 'Add Column' - Add an Index Column (from either 0 or 1 depending on your neeeds.)
Here you go!
Proud to give back to the community!
Thank You!
Thanks a lot for your answer.
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |