Havens Consulting
Video by: Reid Havens
Learn how to leverage a long standing DAX pattern to calculate the top performing name/category and it's corresponding value using DAX measures in Power BI. Plus also see how to optimize the code using DAX Studio.
DAX Function (TOPN)
DAX Function (FIRSTNONBLANK)
Optimizing DAX Video Course
Video by: Reid Havens
Learn how to create a composite model against a Power BI dataset, also known as (DirectQuery for Power BI datasets and Azure Analysis Services) or DQFPBIDAAS for short. 😅
Composite Models against a Power BI Dataset allows you to import tables from other data sources and combine it with your Power BI dataset.
Splitting a Report & Model
DirectQuery for Power BI datasets and Azure Analysis Services
Video by: Reid Havens
Learn how to combine a Time Intelligence table with a matrix visual to propagate date filters through a Drillthrough action in Power BI.
Part 1: Creating MTD/QTD/YTD Filters
Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periods
Part 4: Fiscal Periods
Video by: Reid Havens
Learn how to leverage a bit of bookmark magic to clear/reset slicer selections on a drillthrough page. Even when those slicers have no association with any of the drillthrough filters.
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.
