Remaining Balance from Balance fixed column value

[bideveloper555]

hi 

am trying to achive remaining balance from existing total balance.

below is the data , i am ID, Unique number,Date Amount, Balance i need to get remaining balance data.

ID	uniqueNumber	Date	amount	balance	Remaining Balance
1	10001	01/01/2020	$    10.00	$  200.00	$                       190.00
1	10002	01/01/2020	$       5.00	$  200.00	$                       185.00
1	10003	01/01/2020	$    10.00	$  200.00	$                       175.00
1	10004	02/02/2020	$    20.00	$  200.00	$                       155.00
1	10005	02/02/2020	$    30.00	$  200.00	$                       125.00
1	10006	01/03/2020	$    10.00	$  200.00	$                       115.00
1	10007	02/03/2020	$    20.00	$  200.00	$                         95.00
1	10008	03/03/2020	$  120.00	$  200.00	$                       -25.00
1	10009	04/03/2020	$    10.00	$  200.00	$                       -35.00
1	10010	05/03/2020	$    15.00	$  200.00	$                       -50.00

[AlB · Accepted solution]

@bideveloper555 

Remaining Balance V2 =
Table2[ balance ]
    - CALCULATE (
        SUM ( Table2[ amount ] ),
        Table2[uniqueNumber] <= EARLIER ( Table2[uniqueNumber] ),
        ALLEXCEPT ( Table2, Table2[ID] )
    )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[AlB]

@bideveloper555 

Without the status column how do you determine where to sum and when to subtract?? See what I mean about the importance of a complete explanation?

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[bideveloper555]

this is how scenario works.

lets a Person A has $200 in bank, if he spends $10 on shoes on 1st day remaining balance is 190.Than he spend $5 on food on the same day remaining balance is 190-5 = 185.

lets on 10th day remianing balance is $ 20 and he tries to spend $40 card will be rejected.

[AlB]

@bideveloper555 

You still haven't provided an explanation of the logic behind the calculations. That makes me guess and so we'll very probably waste time. Try this calculated column:

Remaining Balance =
Table2[ balance ]
    - CALCULATE (
        CALCULATE ( SUM ( Table2[ amount ] ), Table2[status] = "pay" )
            + CALCULATE ( SUM ( Table2[ amount ] ), Table2[status] = "do not pay" ),
        Table2[uniqueNumber] <= EARLIER ( Table2[uniqueNumber] ),
        ALLEXCEPT ( Table2, Table2[ID] )
    )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[bideveloper555]

hi 

sorry for mis-representation.

above will work but i think status column is what i will be adding based on remaining balance.

so please ignore status column 

[AlB]

Hi @bideveloper555 

You'll have to explain exactly what you need. Please provide an example based on the data shown, including the expected result and how you get there

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[bideveloper555]

sorry my bad, i made changes to table. i need to find remaining balance after amount spend from full balance