topic 4-4-5 Fiscal Calendar with Leap Year in DAX Commands and Tips

4-4-5 Fiscal Calendar with Leap Year

joshua1990 — Sat, 11 Apr 2020 09:52:56 GMT

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?

Re: 4-4-5 Fiscal Calendar with Leap Year

Anonymous — Sun, 12 Apr 2020 00:05:11 GMT

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

Re: 4-4-5 Fiscal Calendar with Leap Year

joshua1990 — Sun, 12 Apr 2020 07:02:08 GMT

Thanks for the reply!

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

Re: 4-4-5 Fiscal Calendar with Leap Year

Anonymous — Wed, 13 May 2020 11:26:41 GMT

Did you create a custom calendar to resolve this issue?

If so can you share what you did?

Re: 4-4-5 Fiscal Calendar with Leap Year

Anonymous — Wed, 13 May 2020 12:01:15 GMT

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

Re: 4-4-5 Fiscal Calendar with Leap Year

bfuller62 — Thu, 17 Nov 2022 19:21:38 GMT

Were you ever able to get this figured out?

Re: 4-4-5 Fiscal Calendar with Leap Year

VisalSeng — Sat, 01 Jul 2023 02:16:37 GMT

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.

Re: 4-4-5 Fiscal Calendar with Leap Year

ppm1 — Mon, 03 Jul 2023 01:41:45 GMT

VisalSeng Please see if you can adapt this approach.

445 Calendar with 53-Week Years – Hoosier BI

Pat

Re: 4-4-5 Fiscal Calendar with Leap Year

VisalSeng — Tue, 29 Aug 2023 03:04:21 GMT

Thanks you.