Posts filed under Slicers & Filters

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