Posts filed under DAX

Additional Date Period Filters for the Time Intelligence Slicer

Video by: Reid Havens

Part three of four in a series. Building upon the two previous videos where I showed how to create a Time Intelligence Slicer. This video adds date ranges for prior month-to-date, prior quarter-to-date, and prior year-to-date.

RELATED CONTENT ๐Ÿ”—

Part 1: Creating MTD/QTD/YTD Slicer
Part 2: Applying USERELATIONSHIP Function
Part 4: Fiscal Periods

Applying the USERELATIONSHIP Function on a Time Intelligence Slicer

Video by: Reid Havens

Part two of four in a series. Learn how to leverage the USERELATIONSHIP function in DAX to apply time intelligence date filtering only to selected measures.

RELATED CONTENT ๐Ÿ”—

Part 1: Creating MTD/QTD/YTD Slicer
Part 3: Additional Date Periodsโ€‹
Part 4: Fiscal Periods

Creating a MTD/QTD/YTD Time Intelligence Slicer in Power BI

Video by: Reid Havens

Part one of four in a series. Learn how to leverage relationships and DAX calculated tables to create a time intelligence slicer in Power BI. The end result will perform faster and create a better user experience versus creating lots of unique time intelligence DAX measures.

RELATED CONTENT ๐Ÿ”—

Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periodsโ€‹
Part 4: Fiscal Periods