Dynamic Trial Balance with Opening, Debit, Credit, Net Change and Ending Balance
Hello friends I want to calculate the **Opening** **Balance** for the attached Trial Balance, the opening balance should be dynamic based on the selected date in the dates slicer. Then the **Debit** and **Credit** is the Movement between the selected dates in the **dates slicer** The Net Changes is simple = **Debit** - **Credit** Finally, the **Ending Balance** is the sum of all the transactions until the selected slicer **max date** Thanks in advance, I'm able to achieve the same in Power Query, but I like to create the same using DAX.
