Forum Discussion

bideveloper555's avatar
bideveloper555
Helper IV
5 years ago
Solved

Remaining Balance from Balance fixed column value

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 ...
Need Help
Show and Tell
  • AlB's avatar
    AlB
    5 years ago

    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's avatar
AlB
Community Champion
5 years ago

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