cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Sort month depending on 2 criterias : beginning of fiscal year and the end of fiscal year

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 : 

 

chanal_0-1594588753564.png

 

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 !

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IX
Super User IX

Re: Sort month depending on 2 criterias : beginning of fiscal year and the end of fiscal year

@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.

 
Like the post, if that help in solving your problem


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

4 REPLIES 4
Highlighted
Super User IX
Super User IX

Re: Sort month depending on 2 criterias : beginning of fiscal year and the end of fiscal year

@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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper I
Helper I

Re: Sort month depending on 2 criterias : beginning of fiscal year and the end of fiscal year

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 :

 

chanal_0-1594627364648.png

 

 

  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 🙂

Highlighted
Super User IX
Super User IX

Re: Sort month depending on 2 criterias : beginning of fiscal year and the end of fiscal year

@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.

 
Like the post, if that help in solving your problem


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Helper I
Helper I

Re: Sort month depending on 2 criterias : beginning of fiscal year and the end of fiscal year

hI @amitchandak 

 

Wonderful ! Thank you so much !! great blogs of yours !

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors