Hi @Michael_Brits to get the past balance, use this formula:
thisTable.Filter(Date<thisRow.Date).Sort(false,Date).Balance.First()
Then you can add the current balance to it in another column (or this one) to get the current.
1 Like