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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
May_24
Frequent Visitor

Unpivot columns without using unpivot feature

Greetings,

 

I have a table contains (customer, expenses, three columns with three sales centers) I want to unpivot the sales centers to be in one column then connect it to another table contains the quantity sales from each center.

if I used the Unpivot column feature it will cause to duplicate the expenses three time... do you have any idea on the best way to distribute the centers on the customer without duplicating the expenses and the other columns also.

 

Thanks    

2 REPLIES 2
Bmejia
Super User
Super User

Base on what you are saying your data looks something like this.  I am assuming that each center column can only be populated once in each of the three columns.  Otherwise it won't work and we will need more information on what you are trying to accomplish. 

Bmejia_0-1712172611955.png

 

You can create a custom table during the transformation.
=Text.Combine({[North], [West], [East]})

Bmejia_2-1712172966962.png

 

 

 

 

 

Fowmy
Super User
Super User

@May_24 
Sharing a dummy Power BI file representing your scenario would be beneficial. You can save the Power BI file on Google Drive or any other cloud storage platform and provide the link here. Kindly ensure that permission is granted to open the file.

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.