Havens Consulting
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.
Part 1: Creating MTD/QTD/YTD Slicer
Part 3: Additional Date Periods
Part 4: Fiscal Periods
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.
Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periods
Part 4: Fiscal Periods
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.
Video by: Reid Havens
Learn how to count distinct rows in Power Query while maintaining Query Folding! No file download with this weeks video.
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
