Set a calendar diferente comercial year

[peixotolopes]

How can set a calendar that first month is September.

Example

Set2021 for comercial purposes will be the first month of the year 2022 and so on till August, Set 2022 will be the first month 2023.

Many thanks for your help

JL

[selimovd · Accepted solution]

Hey @peixotolopes ,

that's the classical case of a fiscal year.

There are many articles that describe that in detail. Check here the existing dax pattern:

https://www.daxpatterns.com/custom-time-related-calculations/

When it's only about the sorting there is also an article on SQLBI:

https://www.sqlbi.com/articles/sorting-months-in-fiscal-calendars/

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[peixotolopes]

Many thanks for your help