My first Report - need a cumulative line?

[SteveYorks]

Hi, I am building my first report but now need a Cumaltive count line adding.  Below is my simple Graph which shows a field "Income" shown across time.  Bars below the line are Costs and Bars above the line are income.  I need a cumalative line adding which adds the values up cumalatively to show my current £ balance.

I assume I create a new column which i can then add onto the graph.  What would be the formula for this new column?

Thanks in advance.

Steve

[AlexChen]

Hi,

I assume you have a table below.

You can add a measure to your table:

balance = CALCULATE(SUMX(tablex, tablex[cost] + tablex[income]), Filter(ALLSELECTED(tablex), tablex[Index] <= max(tablex[Index])))

Now you can create a chart to show your balance with a cumalative line.

Best Regards

Alex

[Anonymous]

I'll assume you have a column called "Amount".

In theory, your existing graph would have been made by using a measure:

  Total Amount := SUM(MyTable[Amount])

And a cumulative total would look something like:

  Running Total Amount := CALCULATE([Total Amount], FILTER(ALL(MyTable[Date]), MyTable[Date] <= MAX(MyTable[Date]))

The answer would be slightly different if your model contained a separate Calendar table (which, generally... it should).