How to calculate cummulative value according to specific data in a tabular data

DAF 1 Reputation point
2022-10-18T10:13:01.697+00:00

251611-xx.png

Hello everyone,

So, I want to get a cummulative sum for each week (there is 15 week in total) according to the data in "Route" column.
The picture above is how i would like to calculate the cummulative, but i want to do it in power query because the original data is too big to handle in excel.

Thank you in advance

Community Center | Not monitored
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.