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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Brysonds
Helper III
Helper III

Help with Transposing / Pivoting Table

Hi! I would like to transform a table. Is it possible based on the information provided below?

 

Here is my current table - notice there are two unique users that belong to the 'North' Division.

Current Table.JPG

 

I would like to the table to look like this:

New Table.JPG

 

The goal of the transformation is to take the 'Division' column which contains duplicates (because of multiple people belonging to that Division) and instead have a unique list. Then for each additional 'Authorized User' beyond 1, a new column would be created as needed (Authorized User2, Authorized User3, etc.).

 

Is this possible?

 

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@Brysonds

1) Add Column tab - Add Index From Zero

2) Transform Tab - Standard dropdown - Modulo - enter 2 in the dialog

3) select Index Column - Pivot Column - Values Column - select Authorized User - Advanced Options - Do Not Aggregate

4) Rename the 2 new columns

QE - Add Index and Pivot.gif

 

View solution in original post

3 REPLIES 3
Sean
Community Champion
Community Champion

@Brysonds

1) Add Column tab - Add Index From Zero

2) Transform Tab - Standard dropdown - Modulo - enter 2 in the dialog

3) select Index Column - Pivot Column - Values Column - select Authorized User - Advanced Options - Do Not Aggregate

4) Rename the 2 new columns

QE - Add Index and Pivot.gif

 

Hi @Sean.

 

Аctually this model works only if there is no more than two values ​​for one parameter. If there are three or more values, then the appropriate number of values ​​should be set in Modulo. And this is not convenient if the data is updated.

This worked perfectly!!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.