Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreThe FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now
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).
Hi @hayesla96
In addition to 2021, which years have the fifth week in December from 1999?
Regards,
Community Support Team _ Jing
@hayesla96 , see if these can help you to build
https://www.youtube.com/watch?v=JqVnqMLGWDY
https://forum.enterprisedna.co/t/4-4-5-fiscal-year-calendar/6567
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 40 | |
| 37 | |
| 19 | |
| 18 |
| User | Count |
|---|---|
| 69 | |
| 68 | |
| 34 | |
| 33 | |
| 30 |