Forum Discussion
Calculating a Cumulative Sum in Power BI
Community ChampionI would recommend implementing an Index column in Power Query. The solution should then be trivial for either a column or measure formula.
Thanks for the response - I've created the Index Column in Power Query, is there a function I can use for the Cumulative sum in Power Query or should it be done as a calculated column in DAX?
I guess it depends on what you're trying to achieve. For example if you want your visualization to be a matrix or chart, then you can simply use the index to arrange the order of the inventory column.
A calculated cumulative (measure/function) I'm not sure makes sense given your scenario...i.e. when do you decide to "stop" the cumulative count? are you going to specify and index? a date? or no stop at all, and just a sum of the entire inventory running total, which gets you a net sum at the end of your data?