Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Please help : I would like to sorth month depending on 2 criterias :
1- the beginning of fiscal year
2-the end of fiscal year
a fiscal year can last more than 12 months.
example :
1-If fiscal year is between 01/10/2018-30/09/19 => i would like the 1st month order of booking date begins in october, and next month november as number 2
2-if fiscal year is between 01/10/19-31/12/2020 => i would like the 1st month order begins in october, but last month december as number 15 and no more 12
3-if fiscal year is between 01/01/2021-31/12/2021 => 1st month january and 12 months
Thanks !
Solved! Go to Solution.
@chanal , I have this blogpost , where you can get link for the calendar that can start for any of the 12 months with month sort order.
@chanal , The values witch you are showing is not possible, like in the second set in yellow/orange you have two oct with different sort values. Not possible to do that.
You can have a custom year and sort custom month start date.
Hello,
Due to the answer of @amitchandak , I have changed my resquest and make it simplier.
I have removed the case when fiscal year is more than 12 month.
Here is my new example please if you can answer :
1- When Fiscal year or Custom Year begins in this example 01/10/18-30/09/2019, and when the booking date is october, then the sort order must begin in october as number 1.
2-the beginning of the Fiscal or Custom Year can change => it can be 01/01/19-31/12/19, or 01/07/19-30/06/20, etc.. but they all last 12 months
Thank you 🙂
@chanal , I have this blogpost , where you can get link for the calendar that can start for any of the 12 months with month sort order.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |