Running totals without dates or ranking

[Anonymous]

Hi.

How do I make a cumulative column or running total of this data? 

I would like it to look like: 

Sprint          Effort

1                    0

4                  200

5                  1690 (1490 + 200)

6                  2177 (487 + 1690) 

etc.....   

Best regards,

Lisa 

[FreemanZ]

Hi @Anonymous 

try to create a measure with this:

RunningTotal=

VAR CurrentSprint = MAX(TableName[Sprint])

RETURN

CALCULATE(

   SUM(TableName[Effort]),

   FILTER(

       ALL(TableName[Sprint]),

       TableName[Sprint] = CurrentSprint

   )

)

then plot a table visual with [Sprint] column

[Anonymous]

Hi @FreemanZ 

Something is wrong: 

I tried to plot it in a table with and without effort. 

[FreemanZ · Accepted solution]

hi @Anonymous 

sorry, apparently there is a typo, try this:

RunningTotal=

VAR CurrentSprint = MAX(TableName[Sprint])

RETURN

CALCULATE(

   SUM(TableName[Effort]),

   FILTER(

       ALL(TableName[Sprint]),

       TableName[Sprint] <= CurrentSprint

   )

)

[Anonymous]

@FreemanZ It worked, thank you!