Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
61 | |
59 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |