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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
ClosingBalance Formula - incomplete Years
- Thread starter jeancake
- Start date
Excel Facts
When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Similar threads
- Replies
- 2
- Views
- 271
- Replies
- 4
- Views
- 246
