Extended Date Table with 4-4-5 fiscal model

Power Query M Code Showcase
1

Does anyone know how I can update the Extended Date Table provided by Enterprise DNA to accommodate a 4-4-5 fiscal calendar? For example, fiscal period 1 runs from 10/1/24 - 10/26/24, fiscal period 2 ruins from 10/27/24 - 11/23/24, fiscal period 3 runs from 11/24/24 - 12/28/24? @Melissa

2

Hi @FrankPowerBI ,

Thank you for reaching out to the community.

While we wait for other members to share their insights, we’ve taken the liberty of using “Explain Simply ,” one of the tools available within Data Mentor (you can explore it here: https://mentor.enterprisedna.co/explain-simply . It generated the following results:

image
image1162×728 95.2 KB

image
image1165×715 77.7 KB

Feel free to checkout more of our Data Mentor features as you work on your report. These tools are designed to help with tasks like the one you’re working on.

Cheers,

Enterprise DNA Support Team

3

Check out the 4-4-5 Calendars here.
https://hoosierbi.com/2021/07/04/445-calendar-with-53-week-years/