Forum Discussion

sohailstsindia's avatar
sohailstsindia
Helper I
8 years ago
Solved

Runing Balance

how we can calulate runing balence amount.   VOUCHER INVOICE Debit Credit Amount Running Balance OPB-001336 23478 0 600 -600   OPB-001363 23692 0 3390 -3390   OPB-001356 ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi sohailstsindia,

     

    Based on my test, you should be able to just use the formula below to create a new calculated column in your table to get Running Balance. :smileyhappy:

    Running Balance = 
CALCULATE (
    SUM ( Table1[Amount] ),
    FILTER (
        ALL ( Table1 ),
        Table1[SUPLIER] = EARLIER ( Table1[SUPLIER] )
            && Table1[INVOICE] <= EARLIER ( Table1[INVOICE] )
    )
)

     

    Regards

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

sohailstsindia

 

Step#2 Add this Calculated Column

 

Runnning Balance =
CALCULATE (
    SUM ( TableName[Amount] ),
    FILTER ( ALL ( TableName ), [Index] <= EARLIER ( TableName[Index] ) )
)