aggregation

[mrclay82]

Hi,

In Power Query I have 6 columns:

In the column [Warehouse] I have 2 values: “Main DC” and “Second DC”.

In the column [ProductCode] I have 1 value: “IO1234”.

In the column [ProductDescription] I have 1 value: “Product A”.

In the column [Sales Quantity Jan] I have 2 values: “2” which represents the sales for January for “[Warehouse] “Main DC” and “1” which represents the sales for January for “[Warehouse] “Second DC”.

In the column [Sales Quantity Feb] I have 2 values: “2” which represents the sales for February for “[Warehouse] “Main DC” and “1” which represents the sales for January for “[Warehouse] “Second DC”.

In the column [Sales Quantity March] I have 2 values: “2” which represents the sales for March for “[Warehouse] “Main DC” and “1” which represents the sales for January for “[Warehouse] “Second DC”.

I don’t want to differentiate [Sales Quantity Jan], [Sales Quantity Feb] and [Sales Quantity March] per [Warehouse] so I only want one value for [Warehouse] that aggregates the data for the other columns.

The output should be the following columns and values:
In the column [Warehouse] 1 value: “Main DC”.

In the column [ProductCode] 2 values: “IO1234” and “IO1235”.

In the column [ProductDescription] 2 values: “Product A” and “Product B”.

In the column [Sales Quantity Jan] “3” (which represents the sales for January for “[Warehouse] “Main DC” and “1” which represents the sales for January for “[Warehouse] “Second DC”.)

In the column [Sales Quantity Feb] “3” (which represents the sales for February for “[Warehouse] “Main DC” and “1” which represents the sales for January for “[Warehouse] “Second DC”).

In the column [Sales Quantity March] “3” (which represents the sales for March for “[Warehouse] “Main DC” and “1” which represents the sales for January for “[Warehouse] “Second DC”).

How can I achieve this? I tried the Group By option without success.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...