DAX calculating running sum of column

0
votes

I have already tried the various solutions found on the web (which are usually all the same), but nothing works.
As suggested in https://community.powerbi.com/t5/Desktop/Issue-with-Running-Total/td-p/310720
I tried using the dates column as a reference enter image description here

Then I created an index column in Power Query and use this as a reference enter image description here

As you can see it simply doesn't work:
instead of getting a running sum, starting from the first value (€ 37 800.68), I simply get a global sum.

I have also tried creating a Quick New Measure selecting the Running Total option (see the full function automatically generated by Power BI) and then displaying the result with a chart in the report window, but again the result doesn't make sense (I simply get a copy of the field I want to sum...) enter image description here

UPDATE

I implemented the suggestion by @sigdoug but I get the following enter image description here

This is simply adding to each element in the column Amount the following value, forgetting the previous one.

What I mean by running sum is update the sum of the previous calculation.

I should get the following values:
37 800.68
35,845.11
35,348.57‬
35,347.57
...‬ ‬

Can someone help me in getting this right? Thank you

1
daxcumulative-sum

1 Answers

0
votes

Sorry andrea, I should have actually done a bigger test of this (and read the question properly). The following will solve your problem, add this as a calculated column:

SUMX(FILTER('Table','Table'[Column1<=EARLIER
('Table'[Column1])),'Table'[Column2])

column1 being your index and column2 being the value you want added each time.