Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
hayesla96
Frequent Visitor

4-5-4 Calendar Table

Hello, 

 

I need some help creating a date table for my company.

This table should start in 1999, but the actual fiscal calendar started 1/1/2001. Every 5 or 6 years December has a 5th week.  This is because the 4-5-4 is exactly 91 days. 91 days x 4 quarters = 364 days per year. So we lose a day each year in accounting.  When you add in February 29th every 4 years we lose another day. Eventually, we would end up with the year ending earlier and earlier.  The December 5th week is to correct that.  Coincidentally 2021 is a 5 week December (see attached).

hayesla96_0-1623960757687.png

 



2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @hayesla96 

 

In addition to 2021, which years have the fifth week in December from 1999?

 

Regards,
Community Support Team _ Jing

amitchandak
Super User
Super User

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.