cancel
Showing results for
Did you mean:
Highlighted
Helper I

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

Hello,

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 !

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
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

Proud to be a Super User!

4 REPLIES 4
Highlighted
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.

Proud to be a Super User!

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

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

## 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

Proud to be a Super User!

Highlighted
Helper I

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

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

Announcements

#### August Community Highlights

Check out a full recap of the month!

#### August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

#### 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
Top Kudoed Authors