What I thought was quite simple turns out not to be. I need to calculate Rolling 12 Financial Periods and display it in a chart by Fiscal Periods.
If it was months there is kioads of info out there.
I can get to
I have the end date in a Measure. With Months I would use SAMEPERIODLASTYEAR. However this wont work as it is financial periods and they dont align like months.
There must be an easy way to step back 12 Financial Periods (not months)
The date dimension has a date column and a Financial Year Month number
I am sure there must be a real easy way to do this. I feel like I am missing the obvious