←Back to all posts
•3 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Power Query - Create Multiple Running Totals for Different Time Intervals

Hi,

This is the sample layout of my dataset:

Week Month Res Project Area Val1 Val2 Val3
4-Apr-25 Apr-25 IT Proj 01 North 50 100 150
11-Apr-25 Apr-25 IT Proj 01 North 100 150 200
18-Apr-25 Apr-25 IT Proj 01 North 150 200 250
2-May-25 May-25 IT Proj 01 North 200 250 300
4-Apr-25 Apr-25 IT Proj 02 South 10 20 30
11-Apr-25 Apr-25 IT Proj 02 South 20 30 40
18-Apr-25 Apr-25 IT Proj 02 South 30 40 50
2-May-25 May-25 IT Proj 02 South 40 50 60

Im trying to generate this table in Power Query which will add 4 new grouped running total columns for each value columns:

  1. Running Total till date

  2. Running Total Monthly

  3. Running Total Inmonth Only

  4. Monthly Total Static Value

This is the sample output for Val1 column. Will need it repeated for Val2 and Val3 columns also:

Week Month Res Project Area Val1 - RT Overall Val1 - RT Monthly Val1 - RT InMonth Val1 - RT ThisMonth
4-Apr-25 Apr-25 IT Proj 01 North 50 300 50 300
11-Apr-25 Apr-25 IT Proj 01 North 150 300 150 300
18-Apr-25 Apr-25 IT Proj 01 North 300 300 300 300
2-May-25 May-25 IT Proj 01 North 500 500 200 200
4-Apr-25 Apr-25 IT Proj 02 South 10 60 10 60
11-Apr-25 Apr-25 IT Proj 02 South 30 60 30 60
18-Apr-25 Apr-25 IT Proj 02 South 60 60 60 60
2-May-25 May-25 IT Proj 02 South 100 100 40 40
submitted by /u/land_cruizer
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#large dataset processing
#real-time data collaboration
#Power Query
#Running Total
#Val1
#Val2
#Val3
#Dataset
#Time Intervals
#Grouped Running Total
#Project
#Monthly Total
#IT Proj
#Static Value
#InMonth Only