Forum Discussion
Solved
Help with Cumulative Total from Clients Balance Table
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 ...
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!!
VahidDM
Super User
Super UserHi 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!!
Worked! Thanks a lot