If you set up your Date as a multilevel date-type hierarchy, then you can use
[Date].[Year].NextMember as a dimension...
[Date].[Year].PrevMember as another
Then you get:
Just a thought - Can't say that it's going to do the things you want it to.
This is a signature. Everyone gets it.
PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
I'm no expert.
Take my comments at your own risk.
PDI user since PDI 3.1