hayesla96Frequent Visitor5 years ago4-5-4 Calendar Table 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. Th...Show More
amitchandakSuper User5 years agohayesla96 , see if these can help you to build https://www.youtube.com/watch?v=JqVnqMLGWDY https://www.sqlbi.com/blog/marco/2013/02/19/dax-time-intelligence-for-4-4-5-calendar-iso-calendar-and-other-custom-ones-dax-powerpivot/ https://forum.enterprisedna.co/t/4-4-5-fiscal-year-calendar/6567
Related contentFiscal Calendar (4-4-5) Requirements DAX4-4-5 Fiscal Calendar with Leap Year4-4-5 Fiscal Calendar - Month number wrong!Power BI Service refresh taking 4–5 hours, while Desktop takes 5–10 minsCalculate YTD Sales Based on a 4 4 5 Calendar and Excludes Current Period
