Forum Discussion
Balance value calculation
Hi JimB-GA,
Based on my test, you could refer to below steps:
Sample data:
Create two calculated columns:
a = IF([Type]="Debit",-[Amount],[Amount])
Total running = CALCULATE(SUM(Table1[a]),FILTER('Table1','Table1'[Transaction]<=EARLIER(Table1[Transaction])))
And you could see the result:
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/j4kh8ait0z2f69w/Balance%20value%20calculation.pbix?dl=0
Regards,
Daniel He
I notified that I only used one ampersand where you formula used two. Inserting a second & into the formula gave me a value.
I must confess that I was not clear with the calculation I want to perform. Debits need to be subtracted from Credits for the balance column to work. Do I need to create a calculated column for the amount changing the sign on debits?
Thanks again for you help.
JimB
What is the end result you desire? Could you show it in the sample table
| Date | Transaction | Type | Amount |
| 1/1/2018 | 123 | Credit | 1500 |
| 1/1/2018 | 124 | Debit | 420 |
| 1/3/2018 | 125 | Debit | 360 |
| 1/4/2018 | 126 | Credit | 1650 |
| 1/6/2018 | 127 | Credit | 1200 |
| 1/10/2018 | 128 | Debit | 1000 |
Sorry, I should have thought of that earlier!
Date Transaction Type Amount Balance 1/1/2018 123 Credit 1,500 1,500 1/1/2018 124 Debit 420 1,080 1/3/2018 125 Debit 360 720 1/4/2018 126 Credit 1,650 2,370 1/6/2018 127 Credit 1,200 3,570 1/10/2018 128 Debit 1,000 2,570 He said what he needed in his initial post. It was clear. The desired end result is obvious. Why ask again and then never return to give an answer?
