Custom Date Sort

[smc1906]

Hello,

I have the below date table:

I can sort the Months by "MonthNumber" which is great, but I actually need to sort by a different order. I am working from September to August, so I actually need September to be month number 1. How can I add a custom sort order column to this table, so I can define September as month 1?

Thanks!

[dkaushik · Accepted solution]

Hi, @smc1906 

You need to define a calculated column, "FiscalMonthNumber" which starts from Sep to Aug. 

Follow these steps:

Solved: How to assign fiscal month number - Microsoft Power BI Community

If this post helps, then please consider Accept it as the solution and give thumbs up to help the other members find it more quickly.

Thanks,

Dheeraj

[smc1906]

Thank you so much!