Forum Discussion
Creating a date table starting in October
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.
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.
2 Replies
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/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.
