Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 o...
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

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.