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

Download Report From The Blog Files Page
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

Download Report From The Blog Files Page
Posted on September 28, 2021 and filed under Power BI, Intermediate, Power Query.

Improving the Time Intelligence Slicer & Avoiding Circular Dependencies

Video by: Reid Havens

I've improved my time intelligence slicer based on some feedback about a DAX error related to blank dates being evaluated. In this video we'll see how to avoid that plus also prevent any circular dependency errors as well!

RELATED CONTENT 🔗

Part 1: Creating MTD/QTD/YTD Filters
Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periods
Part 4: Fiscal Periods

Download Report From The Blog Files Page
Posted on September 21, 2021 and filed under DAX, Power BI, Intermediate, Slicers & Filters.