filmov
tv
Running Totals in Excel's Power Query: the easy way
Показать описание
As follow up to my previous video on making running totals in Excel's Power Query (Get and Transform) I show a much simpler solution. Thank you to Wyn Hopkins and Peter Bartholomew.
Special thanks to Gráinne Duggan for an important warning. If we make the running total, sort the source data and then refresh, the running total will turn into a mess. You'll see that solution here, too!
#RunningTotals
#RunningTotalsInPowerQuery
- My book: Guerrilla Data Analysis 2nd Edition
Special thanks to Gráinne Duggan for an important warning. If we make the running total, sort the source data and then refresh, the running total will turn into a mess. You'll see that solution here, too!
#RunningTotals
#RunningTotalsInPowerQuery
- My book: Guerrilla Data Analysis 2nd Edition
0:04:54
0:06:32
0:11:51
0:07:26
0:02:00
0:05:32
0:02:51
0:04:03
2:04:14
0:31:16
0:10:09
0:09:43
0:00:51
0:00:09
0:07:31
0:07:25
0:04:39
0:03:58
0:07:56
0:00:50
0:00:50
0:02:57
0:01:08
0:01:40