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
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










