How to Sum each row with the previous ones?

[rashel2002]

Hi Everyone!

i would like to create a new coulmn which is caculating for each row the sum of the rows before it. i know it's hard to understand so here's an example-

 

Thx!

[Greg_Deckler · Accepted solution]

You will want a calculated column and use EARLIER. See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...

[rashel2002]

Hi!

Thanks you! 🙂 Very helpful!