Rolling fiscal year columns
How can I use a date offset type functionality within a sharepoint list where I need fiscal period columns for -1,0,1 fiscal years? Data is queried into a PBI data model where cumulative data needs to be retained year over year by fiscal year and period. It could be a static table or hardcoded logic used to manually assign the current year as 0 each fiscal. This is an interim solution, but looking for a more practical way of managing rolling over fiscal years without adding 12 new columns each year.