How To Create a custom 4-4-5 date table

[BrianJ]

@pete.langlois ,

@Greg has created a terrific DAX Patterns section on nonstandard time intelligence, including how to create 4-4-5 and other calendar variations. Here’s the link – I think this should give you everything you need:

Non-Standard Time Intelligence

The available DAX date intelligence functions in Power BI handle the comparison with previous periods easily for the standard periods of year, quarter, month, and day when using a standard calendar, or a standard fiscal calendar (where quarters start on a 3-month cadence, e.g., April 1, July 1, etc., and aligned to [but offset from] calendar quarters). These functions do not, however, handle weekly comparisons or custom fiscal calendars. Calculation techniques to handle week comparisons and non-…

– Brian