Forum Discussion
Creating a Fiscal Calendar with 52 Weeks
I am trying to create a Fiscal Calendar with Columns:
- Fiscal Year (52 Weeks per Year)
- Fiscal Quarter (November-Jan as First Quarter)
- Fiscal Month (November as starting Month)
- Fiscal Weeks (Sunday as starting Day)
I've tried several tutorials but they don't seem to tally with my 2023 Fiscal Calendar.
Attached picture above shows October 30, 2022 as Fiscal Year 2022, Fiscal Quarter 4, Fiscal Month 12 instead of 2023, 1, 1, respectively.
October 30 should be the starting date with October 28 as ending date of Fiscal Year 2023.
Hi Anonymous,
See attached PBIX. Review the Power Query code and let me know if you have any questions.
Original code from mahoneypat I think.
Modified to suit my application.
2 Replies
Hi Anonymous,
See attached PBIX. Review the Power Query code and let me know if you have any questions.
Original code from mahoneypat I think.
Modified to suit my application.
Sorry, I rushed the reply and PBIX.
I called the main query Date, the query is usually called Fiscal in my Date Dataflow and I merge it with the main Date table, on date. Then expand what you need.