Posts filed under Intermediate

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

Posted on February 18, 2020 by Reid Havens and filed under Intermediate, Performance/Optimization, Power BI, Slicers & Filters, DAX and tagged Slicers Time Intelligence Intermediate DAX.

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

Posted on February 11, 2020 by Reid Havens and filed under DAX, Intermediate, Performance/Optimization, Power BI, Slicers & Filters and tagged Intermediate DAX DAX Table Slicers Time Intelligence.