Is there a SUMIFS equivalent in Power Query?

[JVL]

Is there an equivalent for SUMIFS formula in Power Query? I would like to calculate the yellow column in Power Query which includes a cumulative sum for each account for each month and year. Grouping the columns does not work as I want to have both the monthly and the cumulative value in the data. How do I do this?

 

[smozgur]

It's going to take me some time to read through that enough times to get it fully, but manalive that was more than I expected! Thank you!

You're welcome. Thanks for the feedback.