topic Re: Help with Cumulative Total from Clients Balance Table in DAX Commands and Tips

Help with Cumulative Total from Clients Balance Table

AlbertoPinon — Mon, 19 Sep 2022 22:52:53 GMT

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

Re: Help with Cumulative Total from Clients Balance Table

VahidDM — Mon, 19 Sep 2022 23:23:57 GMT

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

Re: Help with Cumulative Total from Clients Balance Table

AlbertoPinon — Tue, 20 Sep 2022 22:08:22 GMT

Worked! Thanks a lot