Posts tagged #Date Table

Creating Date (Calendar) Hierarchy Columns in Power Query

Video by: Reid Havens

Part two of two of my videos on creating a Power Query Calendar Table. In this video we’ll see how to create the necessary date columns needed for dependent and independent hierarchies.

RELATED CONTENT 🔗

Part 1: Creating a Dynamic Range Calendar Table in Power Query

Posted on October 5, 2021 and filed under Power BI, Intermediate, Power Query.

Creating a Dynamic Calendar Date Range in Power Query

Video by: Reid Havens

Part one of two of my videos on creating a Power Query Calendar Table. In this video we’ll see two methods for creating either a dynamic or relative date range for a calendar table created in the Power Query Editor.

RELATED CONTENT 🔗

Part Two: Creating a Dynamic Range Calendar Table in Power Query

Posted on September 28, 2021 and filed under Power BI, Intermediate, Power Query.

Implementing Different Date Table Hierarchy Types in Power BI

Video by: Reid Havens

Learn about two primary Hierarchy types you can implement on a Date Table in Power BI. I consider it a best practice to include dependent and independent date hierarchies, which can impact how users want to navigate the hierarchy controls in visuals.

Posted on August 31, 2021 and filed under Beginner, Data Modeling.