The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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!
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.
User | Count |
---|---|
15 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
20 | |
12 | |
9 | |
7 |