Cumulative SUM or Running Totals on Dates using only Custom Column in a Query Editor

[vidyasagar159]

Hi All,

I am a beginner. Need some help on running total or cumulative sum on the DATES column using Query editor custom column. 

From the above image I would like to calculate a simple Running Total or Cumulative SUM for "Values" using "As of Date" only for MFlag = 'Flows'. This I want to achieve in a custom column. I don't want to do it in DAX. Because my output values are references to other tables.

Aggregation:

Flows on 07/19/2019 = 3945534366

Cumulative Flow on 08/19/2019 is (3945534366) + (-88750950) = 3856783416

Thanks,

Vidya

[amitchandak]

It is a case of cumulative subtotal. Please refer

https://community.powerbi.com/t5/Desktop/Calculating-Cumulative-Monthly-Totals/td-p/100756

https://community.powerbi.com/t5/Desktop/Cumulative-Subtotals/td-p/395842

https://community.powerbi.com/t5/Desktop/Cumulative-Running-Balance-in-a-Matrix/td-p/490907

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information
Thanks.