Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
kballar1
Helper I
Helper I

Fiscal Calendar Starting in September

I am needing to create a fiscal calendar with no start or end date, with year, quarter, month and day using dax with the fiscal year starting in September. 

I've searched but none of them seem to be what I am needing. Please help. Thank you! 

1 REPLY 1
lbendlin
Super User
Super User

Save your energy and create that table outside of Power BI, for example in an Excel file in a SharePoint.

with no start or end date, 

That's not such a great idea.  Try to limit the range to whatever makes sense for your business and avoid fantasy dates like 1899-12-30 or 1900-01-01 or 9999-12-31.  Better to have blanks than to have these horrible placeholders.

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.