Are you still looking for assistance with this? i think the multiple conditions prevented much engagement. Could you explain the fiscal year issue in detail as well as correcting for that alone might be its own question. Breaking these up one at a time might help us to assist.
if you have found a solution, please let us know as well.
Essentially I've got some views I use to compare Current Year to Date versus Prior Year to Date but the problem I'm running into is that the 11th of Dec 2018 is a Tuesday whereas the 11th of Dec 2017 was a Monday. I need to compensate for the difference since day of week is significant in my work.
So I'm looking for a way to adjust the Prior Year to line up with Current year so I can spit out a more accurate view to show variance by day, week, etc.