Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |