Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

Mobile calendar Previous year

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 😁



Super User
Super User

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.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.