Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
87
Views
Topic starter
Hello,
I'll explain my setup. My first column is called 'Month / Year' (a date column). My second column is called 'Operating Area' (a text column) and my third column is called 'Hours' (a number column).
I need to create a column that provides a rolling year-to-date sum of 'Hours' for each 'Operating Area'
Posted : 03/06/2023 8:10 am
Perhaps Phil's blog post on Grouped running Totals in PQ is what you need.
https://www.myonlinetraininghub.com/grouped-running-totals-in-power-query
Posted : 03/06/2023 9:48 am
