With Power Query it's better to calculate it separately (Opening Balance query in attached file), result will be like and Closing Balance is calculated as =SUBTOTAL(109,[Amount]) + Opening_Balance[Opening Balance] group transactions PQ.xlsx48...
With Power Query it's better to calculate it separately (Opening Balance query in attached file), result will be like and Closing Balance is calculated as =SUBTOTAL(109,[Amount]) + Opening_Balance[Opening Balance] group transactions PQ.xlsx48 KB Like 0 Reply Norman_McIlwaine ...