https://www.myonlinetraininghub.com/excel-forum/power-query/running-balance-based-on-difference-of-2-rows-plus-the-previous-row My Online Training Hub Discussion Board en-US Sun, 14 Jun 2026 00:40:20 +0000 wpForo 60 https://www.myonlinetraininghub.com/excel-forum/power-query/running-balance-based-on-difference-of-2-rows-plus-the-previous-row#post-28417 Wed, 03 May 2023 19:48:48 +0000 Power Query John Canlas https://www.myonlinetraininghub.com/excel-forum/power-query/running-balance-based-on-difference-of-2-rows-plus-the-previous-row#post-28417 https://www.myonlinetraininghub.com/excel-forum/power-query/running-balance-based-on-difference-of-2-rows-plus-the-previous-row#post-28412 Wed, 03 May 2023 12:34:49 +0000 Power Query Running Totals would not work without modification. So, I've written a different query that uses List.Sum and List.FirstN to SUM the differences between each row.  This requires creating a temp column to calculate these differences, then you just sum them. See attached file. Regards Phil]]> Power Query Philip Treacy https://www.myonlinetraininghub.com/excel-forum/power-query/running-balance-based-on-difference-of-2-rows-plus-the-previous-row#post-28412 https://www.myonlinetraininghub.com/excel-forum/power-query/running-balance-based-on-difference-of-2-rows-plus-the-previous-row#post-28409 Wed, 03 May 2023 00:57:28 +0000 here, come back if you need further help.]]> Power Query Jessica Stewart https://www.myonlinetraininghub.com/excel-forum/power-query/running-balance-based-on-difference-of-2-rows-plus-the-previous-row#post-28409 https://www.myonlinetraininghub.com/excel-forum/power-query/running-balance-based-on-difference-of-2-rows-plus-the-previous-row#post-6291 Tue, 02 May 2023 22:40:40 +0000 Cash in Payout Running Balance 0.25 0 -0.25 0.75 0 -1 1.5 0.5 -2 1.25 0.5 -2.75 1 0 -3.75 0.25 0 -4 0.75 0.3 -4.45 0.5 0 -4.95 2.25 0 -7.2 2.25 0 -9.45 0.75 2.5 -7.7 1 0 -8.7 Can anyone help me please apply this in power query? I know I could just use the basic formula, but the reason why I want it in power query is because, I also have an updating data that I have also made some formatting in power query and I wanted to integrate this with my existing. Appreciate if you can be detailed in the explanation that you will be providing. Thank you so much in advance. Here is the link to my excel file: https://1drv.ms/x/s!AtBSy5wV0oBqgvIdcz8lLtx9V2wo3g?e=lqbbaQ   Kind regards, John]]> Power Query John Canlas https://www.myonlinetraininghub.com/excel-forum/power-query/running-balance-based-on-difference-of-2-rows-plus-the-previous-row#post-6291