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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
varunvyas
New Member

Merge 17 columns of data to populate single column with all list of values

I have table as source for my report where data values are coming in from 17 different columns

e.g.

 

employee #      Level_1_User      Level_2_User      Level_3_User     Level_4_User

N000789            N000123             N000234            N000345            N000456

N000147            N000123             N000234            N000876             

N000852            N000123             N000963            N000632            N000888

 

 

For above example I wanted to create a single column that sources values from Level_1_User, Level_2_User,Level_3_User,Level_4_User and generates the distinct list of values as result column.

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@varunvyas

 

Hi, In Query Editor you can Select Employee# column and unpivot other columns. After that select the column and Remove Duplicates (In Transform Menu)

 

Regards

Victor

Lima - Peru




Lima - Peru

View solution in original post

1 REPLY 1
Vvelarde
Community Champion
Community Champion

@varunvyas

 

Hi, In Query Editor you can Select Employee# column and unpivot other columns. After that select the column and Remove Duplicates (In Transform Menu)

 

Regards

Victor

Lima - Peru




Lima - Peru

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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