Tag: Holiday Table

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 Tips: Retrieving Previous Value Excluding Weekends & Holidays

Power BI Tips Retrieving Previous Value Excluding Weekends and Holidays

In this post, I will show you some Power BI tips and techniques on finding the previous value that accounts for weekends and holidays. This came up in a post by Brian Julius in the Enterprise DNA forum. You may watch the full video of this tutorial at the bottom of this blog. The developer

Continue reading

Creating A Calendar Table For Holidays In Power BI

This tutorial will address a common time intelligence issue about creating a Power BI calendar table with only holidays. You may watch the full video of this tutorial at the bottom of this blog. For time intelligence, the creation of a holiday table is a weird topic to start but it is one of the

Continue reading