Help with Cumulative Total from Clients Balance Table

[AlbertoPinon]

This is a clients balance table

I want the Column that says [Cumulative Saldo Final] to output in the table:
$175,948.8
$189,462.8
$203,517.36
$27,568.56
$66,418.72
and so on

So basically the column [Cargo] should add to the cumulative column, and the [Abono] column should subtract from the cumulative column.

Thank you very much, I've been struggling with this

[VahidDM · Accepted solution]

Hi @AlbertoPinon 

Try this measure:

Cumulative Saldo Final = 
CALCULATE (
    SUM ( 'Table'[Cargo] ) - SUM ( 'Table'[Abono] ),
    REMOVEFILTERS ( 'Table'[Fecha] ),
    'Table'[Fecha] <= MAX ( 'Table'[Fecha] )
)

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[AlbertoPinon]

Worked! Thanks a lot