cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MaxTrumblay
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Sean Community Champion
Community Champion

Re: Custom 445 Fiscal Year Calendar

2 REPLIES 2
Sean Community Champion
Community Champion

Re: Custom 445 Fiscal Year Calendar

Highlighted
MaxTrumblay
Frequent Visitor

Re: Custom 445 Fiscal Year 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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors