Custom 445 Fiscal Year Calendar

[MaxTrumblay]

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

[Sean · Accepted solution]

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/

[MaxTrumblay]

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