Forum Discussion
JS
Helper II
Helper IIHelp in Data modelling
Hello. I need some help with data modelling here! I have the table below - Buyer Green Apple Red Apple Orange Pineapple Kiwi Strawberry James 1 0 0 0 0 0 James 0 0 0...
Yes, it can be done easily in Power Query:
(1) unpivot all the non-Buyer columns, so that you get a table with 3 columns: Buyer, Fruit, Qty
(2) group by both Buyer and Fruit columns, summing over Qty
(3) finally, pivot the Fruit and Qty columns
DAX0110
Resolver V
Resolver VYes, it can be done easily in Power Query:
(1) unpivot all the non-Buyer columns, so that you get a table with 3 columns: Buyer, Fruit, Qty
(2) group by both Buyer and Fruit columns, summing over Qty
(3) finally, pivot the Fruit and Qty columns
JSThank you!!!! Worked perfectly!!!!