I'm using the closing balance formula in PowerPivot to get the end of Year Balances from and account history table for multiple years. This issue I'm having is that I would like to show the year end balances for the last couple of years, but i would also like to show the year end balance as of August 2023, but because 2023 is an incomplete year I get no result for 2023. I'm using year as the row and Closing balance month as the formula. How can I get the closing balance to show as of August 2023?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
ClosingBalance Formula - incomplete Years
- Thread starter jeancake
- Start date
