Mobile calendar Previous year

[Giulia94444]

Hi guys,

I need your help. My year starts in September and ends in August so I have created e calendar where the first month is September and the last month is August.

I need to create e measure that calculate previous year, for my seasons.

For example, if I select 2° season, I need to see a column Previous Year where I can see sales of  september 2021 - august 2022

Is it possibile?

thank you all 😁

[lbendlin]

Extend your calendar table so it covers all the years that can be the source or destination of a time intelligence calculation. Then you can use things like SAMEPERIODLASTYEAR, even with your shifted fiscal calendar.