Tag: Perpetual Holiday Calendar

Perpetual Holiday Calendar – POTW #12 (Power Query Solution)

Perpetual Holiday Calendar – POTW #12 (Power Query Solution)

In this blog post, we’ll explore my solution to Problem of the Week #12. For this challenge, we revisited Enterprise DNA’s maiden Problem of the Week challenge, where we created a perpetual holiday calendar from a mix of specific and relative dates. But this time around, we will be using only Power Query. You can

Continue reading

Power BI Holiday Calendar – Calculate Date W/DAX

Creating a Power BI holiday calendar is crucial for many time intelligence calculations. In this tutorial, I’m going to show you how to calculate specific holiday dates using DAX measures. You can watch the full video of this tutorial at the bottom of this blog. This example came from one of the Enterprise DNA initiatives

Continue reading