Uploaded August 2026 | Updated November 2026, 12 hours ago
DAX has shipped more new surface area since 2022 than in the five years before it, and most of that never made it into anyone's habits. Part 4 of the series covers the five additions that change how you actually write code, where each one earns its keep, and where it still falls short.
User-defined functions are the headline. Reusable, parameterized DAX stored as a model object, so the pattern you keep copying between six measures finally lives in one place. We build one, call it with and without default parameters, and get into the limitations that are still there in the current release.
From there it's window functions (OFFSET, INDEX, WINDOW, RANK, ROWNUMBER) for row-relative math that time intelligence can't reach, INFO functions for querying your own model metadata as a table, EVALUATEANDLOG for debugging without littering the model with temporary measures, and dynamic format strings that follow context instead of sitting fixed on the measure.
The last stretch runs through the smaller additions that still come up: TREATAS, GROUPBY, DETAILROWS, ERROR, and TOCSV/TOJSON. None of them need a section of their own, but skipping them leaves gaps.
CHAPTERS π¬
00:00 -- What counts as modern DAX
02:43 -- User-defined functions
09:20 -- Window functions
13:40 -- INFO functions
15:59 -- EVALUATEANDLOG
17:34 -- Dynamic format strings
19:44 -- Smaller additions and closing takeaways
RELATED CONTENT π
DAX Foundations Guide (Series Part 1) -- go-ae.org/hc-yt-dax-foundations-guide
DAX Context Guide (Series Part 2) -- go-ae.org/hc-yt-dax-context-guide
DAX Patterns Guide (Series Part 3) -- go-ae.org/hc-yt-dax-patterns-guide
Modern DAX Guide (Series Part 4) -- go-ae.org/hc-yt-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=ZVFzpDzQs1o
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
Analytic Endeavors -- analyticendeavors.com/make-an-enquiry.html?ae_source=HC&utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #Fabric #microsoft #businessintelligence #datascience #data #dataanalytics #excel #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel
DAX has shipped more new surface area since 2022 than in the five years before it, and most of that never made it into anyone's habits. Part 4 of the series covers the five additions that change how you actually write code, where each one earns its keep, and where it still falls short.
User-defined functions are the headline. Reusable, parameterized DAX stored as a model object, so the pattern you keep copying between six measures finally lives in one place. We build one, call it with and without default parameters, and get into the limitations that are still there in the current release.
From there it's window functions (OFFSET, INDEX, WINDOW, RANK, ROWNUMBER) for row-relative math that time intelligence can't reach, INFO functions for querying your own model metadata as a table, EVALUATEANDLOG for debugging without littering the model with temporary measures, and dynamic format strings that follow context instead of sitting fixed on the measure.
The last stretch runs through the smaller additions that still come up: TREATAS, GROUPBY, DETAILROWS, ERROR, and TOCSV/TOJSON. None of them need a section of their own, but skipping them leaves gaps.
CHAPTERS π¬
00:00 -- What counts as modern DAX
02:43 -- User-defined functions
09:20 -- Window functions
13:40 -- INFO functions
15:59 -- EVALUATEANDLOG
17:34 -- Dynamic format strings
19:44 -- Smaller additions and closing takeaways
RELATED CONTENT π
DAX Foundations Guide (Series Part 1) -- go-ae.org/hc-yt-dax-foundations-guide
DAX Context Guide (Series Part 2) -- go-ae.org/hc-yt-dax-context-guide
DAX Patterns Guide (Series Part 3) -- go-ae.org/hc-yt-dax-patterns-guide
Modern DAX Guide (Series Part 4) -- go-ae.org/hc-yt-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=ZVFzpDzQs1o
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
Analytic Endeavors -- analyticendeavors.com/make-an-enquiry.html?ae_source=HC&utm_source=youtube-hc&utm_medium=video&utm_campaign=ZVFzpDzQs1o
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #Fabric #microsoft #businessintelligence #datascience #data #dataanalytics #excel #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel










