Get the value of previous row in a table and do an accumulated row by row

[ATO23]

Hello to everyone,

This is my first post in this forum.

I'm struggeling a bit with a formula to get the previous row value and get an accumulated row by row. I don't have any dates in my file.

Please see an example in excel on below of what I would need to get.

Many thanks in advance for your support.

Kind regards!

[ATO23]

Hey, many thanks! that works perfectly!

[FrankAT]

Hi @ATO23 ,

you can do it like this:

Running Total = 
CALCULATE(SUM('Table'[Value]), FILTER(ALL('Table'), MIN('Table'[Value]) >= 'Table'[Value]))

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Jihwan_Kim · Accepted solution]

Hi, @ATO23 

Please check the below picture and the sample pbix file's link down below.

Accumulate Measure =

CALCULATE (

SUM ( 'Table'[Value] ),

FILTER ( ALL ( 'Table' ), 'Table'[Type] <= MAX ( 'Table'[Type] ) )

)

https://www.dropbox.com/s/ijbt67ccczcnf10/ato.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM