Forum Discussion
Solved
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)...
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/
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/
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