4-4-5 Fiscal Calendar with Leap Year

[joshua1990]

Hey everyone!

Is there any chance to expend a classic 4-4-5 Fiscal Calendar to a 4-4-6 approach (last quarter) for leap years?

We have a Fiscal Calendar that starts every year with the first Monday after the last 4-4-5 period.

This year starts on 30.12.2019 and will end on 10.01.2021.

How would you include that in a calendar build with dax?

[VisalSeng]

@joshua1990 Do you can find solution for this 4-4-5 calendar and 4-4-6 for leap year at December? I also meet calendar issue as you ask but I don't have solution yet. Hope you can share your solution.

[ppm1]

@VisalSeng Please see if you can adapt this approach.

445 Calendar with 53-Week Years – Hoosier BI

Pat

[VisalSeng]

Thanks you.

[bfuller62]

Were you ever able to get this figured out?

[Anonymous]

I've never heard of any kind of 4-4-6 approach. Probably not possible but it's rather easy to create any custom calendars. You can define anything you want as long as it's logical.

Best
D

[joshua1990]

Thanks for the reply!

Since 4-4-5 has only 364 days we need to have a 6 week December every several years.

[Anonymous · Accepted solution]

Advice is this: remember that if you assign the same ordering number (say, in a year) to 2 different days in a year, they'll be treated as one and the same day in calculations that will only use the numbers; they'll be indistinguishable from this point of view. If you assign something like -100 to a day, it'll be ignored in such calculations when they are properly crafted.

Best
D

[Anonymous]

Did you create a custom calendar to resolve this issue?

If so can you share what you did?