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.
My Patreon Page: https://www.patreon.com/Data
For an intro to Get & Transform (Power Query) try my Lynda.com course:
My book: Guerrilla Data Analysis 2nd Edition
My old blog: http://datascopic.net/blog-2-2