Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
anthony44
New Member

Transform Data : multiple columns -> one dimension

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.

 

 

 

 

 

1 ACCEPTED SOLUTION
fhill
Resident Rockstar
Resident Rockstar

Hope this helps...  All of these screen shots come from the Query Editor in Power BI

 

Your original data:

Capture.PNG

 

Select the 3 Area Columns and choose 'Unpivot Columns' from the Transform tab

Capture2.PNG

 

Now under 'Add Column' - Add an Index Column (from either 0 or 1 depending on your neeeds.)

Capture3.PNG

 

Here you go!

Capture4.PNG




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




View solution in original post

2 REPLIES 2
fhill
Resident Rockstar
Resident Rockstar

Hope this helps...  All of these screen shots come from the Query Editor in Power BI

 

Your original data:

Capture.PNG

 

Select the 3 Area Columns and choose 'Unpivot Columns' from the Transform tab

Capture2.PNG

 

Now under 'Add Column' - Add an Index Column (from either 0 or 1 depending on your neeeds.)

Capture3.PNG

 

Here you go!

Capture4.PNG




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




Thanks a lot for your answer.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.