Notifications
Clear all
Power Pivot
3
Posts
2
Users
0
Reactions
195
Views
Topic starter
Hi
The year end date has been changed as from December to March. This means that all my pivot tables, reports etc need to be changed to reflect the change. January is now month 10 and not month 1 and it moves into a different year!)
The date table is extensive. Should I change the existing table, create a new table and import it (This would be the last resort!), or is there an easy way to get round the problem.
How do I update the results whatever I do?
Thank you.
Geoff
Posted : 04/01/2024 4:46 pm
Hi Geoff,
I would add the fiscal periods to the existing date table. Then you will have to replace the dates used in the PivotTables to the fiscal periods you've added.
Mynda
Posted : 04/01/2024 7:23 pm
Topic starter
Thank you Mynda
Great answer! Thank you!
Geoff
Posted : 05/01/2024 6:58 am
