Modern DAX in Power BI: UDFs, Window Functions, INFO & More (Part 4) @HavensConsulting
Modern DAX in Power BI: UDFs, Window Functions, INFO & More (Part 4)  @HavensConsulting
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
Modern DAX in Power BI: UDFs, Window Functions, INFO & More (Part 4)Data Modeling vs DAX in Power BI: Solving Problems the Right Way (with Markus Ehrenmueller-Jensen)Multi-Line KPI Data Labels for Native Visuals in Power BI !!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)
Havens Consulting |

Modern DAX in Power BI: UDFs, Window Functions, INFO & More (Part 4)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER