The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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]})
@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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
77 | |
76 | |
36 | |
31 | |
29 |
User | Count |
---|---|
93 | |
79 | |
57 | |
48 | |
48 |