Creating a date table starting in October

[Anonymous]

Hi i'm slightly confused. My sales data starts in October however power bi automatically orders the dates from the next january. is it posible/how would i be able to make a date table starting from october to enable me to measure month on month sales.

Any help would be very much appreciated. 

[v-jingzhang · Accepted solution]

Hi @Anonymous 

You can add a fiscal month column to Date table. Then sort Calendar Month column by Fiscal Month column. In this article Sorting Data by Fiscal Year in Power BI, it creates a date table whose fiscal year starts in April. You can modify it to October accordingly. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[VahidDM]

Hi @Anonymous 

Check this link:

https://www.vahiddm.com/post/creating-calendar-table-with-3-steps

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/