DAX Fundamentals Part 3: The Patterns That Make Reports Work @HavensConsulting
DAX Fundamentals Part 3: The Patterns That Make Reports Work  @HavensConsulting
Uploaded June 2026 | Updated November 2026, 1 day ago
You've learned how filter context and CALCULATE actually work. This is where it pays off. Part 3 of the DAX Fundamentals series covers the patterns you'll keep reaching for in real models, and why they behave the way they do.

We get into time intelligence (YTD, QTD, prior cycle, and why these functions return tables of dates rather than numbers), variables for cleaner and faster formulas, and SWITCH as the cure for nested IF chains nobody wants to maintain. Then inactive relationships and USERELATIONSHIP for when one fact table has two date columns fighting over the same date table.

The pattern that saves the most pain is calculation groups. Write three base measures, add one calc group with YTD, Prior Cycle, and YoY%, and you've replaced nine measures (and growing) with something you maintain in one place.

The video closes on the part most people skip: how the engine splits work between the Storage Engine and the Formula Engine, and why pushing work toward simple aggregations on a star schema is the difference between fast DAX and slow DAX.

RELATED CONTENT πŸ”—
DAX Foundations Guide (Series Part 1) -- go-ae.org/hc-yt-p3-dax-foundations-guide
DAX Context Guide (Series Part 2) -- go-ae.org/hc-yt-p3-dax-context-guide
DAX Patterns Guide (Series Part 3) -- go-ae.org/hc-yt-p3-dax-patterns-guide
Modern DAX Guide (Series Part 4) -- go-ae.org/hc-yt-p3-modern-dax-guide

BECOME A CHANNEL MEMBER πŸŽ‰
-- youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join

CHECK OUT OUR MERCH STORE πŸ‘•
-- havens-consulting.creator-spring.com

LET'S CONNECT! πŸ§‘πŸ½β€πŸ€β€πŸ§‘πŸ½ 🌟
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting

BUSINESS PAGES πŸ“„
Home Page - havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=_McUlXEyWyg
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=_McUlXEyWyg
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=_McUlXEyWyg
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=_McUlXEyWyg
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=_McUlXEyWyg
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=_McUlXEyWyg
Contact & Support - havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=_McUlXEyWyg
Analytic Endeavors-- go.analyticendeavors.com/39dda7c7fe

EMAIL US AT πŸ“§
info@havensconsulting.net

#PowerBI #DAX #MicrosoftFabric #DataModeling #BusinessIntelligence
DAX Fundamentals Part 3: The Patterns That Make Reports WorkDemystifying Fabrics SQL Architecture & Best Practices (with Bogdan Crivat)SQLBits Unplugged: Inclusivity, Costumes & the Power of CommunityKeeping Query Folding by Outsmarting Columns from Examples in Power QueryFive Tabular Editor 3 Hidden Tips for Power BI!Adding 3 or More Advanced Filter Conditions in Power BIStarter Extensions for Visual Studio Code and Power BI (with Ε tΔ›pΓ‘n ReΕ‘l)Power BI CI/CD, the REST API, and VSCode (with Gerhard Brueckl)DAX Query Best Practices and Historical Context (with Jeffrey Wang)ITS HERE! Dark Mode for Power BI Desktop πŸ“’Data Warehousing with Microsoft Fabric (with Andy Cutler)Avoiding HIDDEN Visual-Level Filters with Field Parameters
Havens Consulting |

DAX Fundamentals Part 3: The Patterns That Make Reports Work

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER