Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
Many thanks for your help
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |