Forum Discussion
Calculating a Cumulative Sum in Power BI
Hi everyone, I need some help putting together a calculated column or measure for a Net Requirements report in Power BI. Here is a sample of my data: What I need is a a cumulative ...
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?