How to calculate closing balance

[rajasekar_o]

Hi team 

How to calculate closing balance 

[Anonymous · Accepted solution]

Hi @rajasekar_o ,

I created a sample pbix file(see the attachment), please find the details in it. 

1. Add a index column in Power Query Editor

2. Create a measure as below to get the closing balance

closing balance = 
VAR _index =
    SELECTEDVALUE ( 'Table'[Index] )
RETURN
    CALCULATE (
        SUM ( 'Table'[credit] ) - SUM ( 'Table'[debit] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Index] <= _index )
    )

Best Regards

[Ahmedx]

Share sample pbix file to help you.

[rajasekar_o]

I have debit credit data only i want to calculate closing balance