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

Template for Extracting Report Level Measures from Live Connection PBIX Files

Video by: Reid Havens

Learn about a report I built that will connect to any local (PBIX) file that is using a live connection, and extract any report-level measures from that file. Live connections include (PBIX) files connected to: SQL Server Analysis Services (SSAS) models, Azure Analysis Services (AAS) models, and Power BI Shared Datasets.

Stephanie Bruno - Power BI Field Finder

Tweet from Marco Russo about unzipping PBIX files

Posted on January 28, 2020 and filed under Advanced, DAX, Power Query.