Forum Discussion

May_24's avatar
May_24
Frequent Visitor
2 years ago

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    

Need Help
Tutorial Requests

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    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.

  • Bmejia's avatar
    Bmejia
    Super User
    2 years ago

    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. 

     

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