Hi,
I have a spreadsheet of over 100,000 rows with the 4 columns: "Component", "Subcomponent", "Date", "Amount".
Each component will have the same subcomponents.
I need to create a column with a running total with both the Component and Subcomponent being "Sumifs-criteria" as well as a criteria stating to sum any date after the current date. As the size of the datatabel makes it almost impossible to do sumifs formulas in ordinary excel, I was hoping to do this in power query in some way.
Anybody up for the challenge? Would be greatly appreciated!
Kind Regards,
Ulsq
I have a spreadsheet of over 100,000 rows with the 4 columns: "Component", "Subcomponent", "Date", "Amount".
Each component will have the same subcomponents.
I need to create a column with a running total with both the Component and Subcomponent being "Sumifs-criteria" as well as a criteria stating to sum any date after the current date. As the size of the datatabel makes it almost impossible to do sumifs formulas in ordinary excel, I was hoping to do this in power query in some way.
Anybody up for the challenge? Would be greatly appreciated!
Kind Regards,
Ulsq
Last edited:
