Results 1 to 2 of 2

Thread: Power Query Running Total with Multiple Criteria

  1. #1

    Power Query Running Total with Multiple Criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Click image for larger version. 

Name:	Skærmbillede 2017-01-19 kl. 21.56.33.jpg 
Views:	30 
Size:	59.0 KB 
ID:	6287
    Anybody up for the challenge? Would be greatly appreciated!

    Kind Regards,
    Ulsq
    Last edited by Ulsq; 2017-01-19 at 08:58 PM.

  2. #2
    Is there a particular reason it needs to be a column? Those kinds of calculations are exactly what PowerPivot Measures were designed for. You probably could produce that with Power Query, but it would be a lot easier in PowerPivot.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •