O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

445 dates and irregularities

Manufacturing and retail companies often use a special type of calendar, which ensures that all months have an equal number of days. This is commonly called a 445 calendar, which indicates that a month is made of 4 weeks, with the next month comprising 4 weeks, and the final month (in the quarter) comprising of 5 weeks. The next quarter follows the same pattern of 2 x 4 weeks and then a 5-week month.

Month names in the 445 calendar do not always equate to the calendar month. The 445 calendar month of January may run into February, and December may run into January (in fact this is frequently the case). Further, the week can start on any day of the calendar week, and a 445 calendar's month never end on the same calendar ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required