Power Query - Append Grouped Rows based on specific columns AND row values

[lzcrss2]

Hi! My data set has 117,000 rows and 14 columns. It is at an item and week level. There is a week column, an item description column, 11 columns of characteristics that describe/classify the item, and finally the value column (cost).

Is it possible, via M code or otherwise, for me to group by certain columns, and only for certain row values, and then append those groupings onto the existing data set?

Here is a fake example data set. In this example, I don't want to append rows for ALL combinations of "Type"+"Size"+"Source", I just want to see all weeks of data for the 2 specific combos at the bottom: Large apple from supermarket and Small orange from farmer's market. This example is just in an Excel spreadsheet where I used SumIfs just to illustrate what I want my query to do.

 

[GraH]

Filter your data twice for both criteria, then append data again.

You can do this in 1 query, where you refer to an earlier step when needed (m-code knowledge required), or in different queries, referring to another query if you need a UI-based solution.

 

[lzcrss2]

Oh my gosh!! Thank you so much!! I am not at my computer, but am going to try it tonight!