Weekly Average Excluding Dates with No (Zero) Orders

Hello @ScottTPA,

To create a “Holiday Table” in Power BI. Our experts @Melissa and @BrianJ had created several videos on this topic and on our forum challenges were also hosted by our experts and members provided wide variety of solutions in those challenges. I’m providing a link below of the posts from our Forum, blog links as well as video links for the reference purposes.

Hoping you’ll find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Note: In order to view the entire Forum posts, please click onto the link and not onto the “expand/collapse” button.

Thanks and Warm Regards,
Harsh

https://forum.enterprisedna.co/t/perpetual-holiday-calendar-problem-of-the-week-1-dax-solution/13594

https://forum.enterprisedna.co/t/how-to-create-a-holiday-table-in-power-bi-time-intelligence-in-power-bie/8061