Holidays in Date Table

[BrianJ]

@jmolina,

Indeed, I can. Here’'s a blog entry on the topic, with a video I created at the end on how to develop your holiday table:

Creating A Holiday Calendar Table In Power BI | Enterprise DNA

Also, Problem of the Week #1 showed how to create a perpetual holiday table.

Problem of the Week #1 (DAX) - Perpetual Holiday Calendar

[image] OK, here we go! Problem of the Week #1 is live! For background on this initiative, check out this post and the live launch video that Sam and I did today on YouTube. Background on This Week’s Problem Creating a holiday table is critical for a number of time intelligence calculations, most commonly calculating net workdays excluding holidays between two dates. In creating a holiday table, most commonly dates are pulled off the web. This works fine if the dates provided are specific, …

Once you have your holiday table in place, when you invoke the query for @melissa’s Extended Date Table, it will ask for the column in your holiday table with the dates of the holidays.

Once you specify this, it will automatically incorporate the holiday dates into the relevant fields of the date table.

I hope this is helpful.

• Brian