Ordering month numbers - Circular dependency was detected

[wilbur750]

Hi all

I have a monthly data table that has the Month-name in full e.g. January and the fiscal year e.g. 2017-18.  I have created a Month-order column where April =1, May = 2, etc. which is calculated if Month-name="April" then 1, etc. However, when I try to sort the Month-name so it shows on a chart axis as April, May, June, etc, I am trying to sort the Month-name by Month-order column but I get a circular dependency was detected error. 

I think I can see why its telling me that as the month-order is calculated from the name, but how do I get around it?  I cant add the month number to the raw data file.

Thanks

[wilbur750]

Thanks!  I have created a custom calendar now and it sorts the issue 🙂

[vicky_ · Accepted solution]

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

SQLBI has a pretty good write-up about doing a custom fiscal year calendar, have a read and hopefully that will answer your question. You will probably need to create a custom calendar, depending on what your data looks like.