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.
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!
Thanks a lot for your answer.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.