Forum Discussion
Custom 445 Fiscal Year Calendar
Hi everyone,
I can't figure out how to create a custom 445 Fiscal Year calendar with those specifications:
Starts: "2015-11-01" equal to FYear 2016; FQuarter 1; FMonth 1; FMonth name (November); FWeek 1, then when the Year end it need to restart has "2016-10-30" FYear 2017; FQuarter 1; FMonth 1; FMonth name (November); FWeek 1 and so on.
I found a couple of possible solutions on the forum, but none was doing what I need. The FWeeks need to restart when the new FYear starts.
Thanks for your help,
Max
I have not used this but I remember MattAllington had a post about this
https://powerpivotpro.com/2015/03/create-a-445-calender-using-power-query/
http://exceleratorbi.com.au/convert-monthly-budget-weekly-buckets-445-calendar/
2 Replies
- Sean
Community Champion
I have not used this but I remember MattAllington had a post about this
https://powerpivotpro.com/2015/03/create-a-445-calender-using-power-query/
http://exceleratorbi.com.au/convert-monthly-budget-weekly-buckets-445-calendar/
- MaxTrumblayFrequent Visitor
Thanks, it's working perfectly.
Also, I used the technique used to create the "Fin Month Number" on the following website:
http://www.excelguru.ca/blog/2016/01/06/creating-a-custom-calendar-in-power-query/ and it's
also explained it this video https://www.youtube.com/watch?v=JqVnqMLGWDY
Regards,
Max