Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |