Introducing DAX User-Defined Functions (UDF)

2025

TL; DR

A user-defined function is a DAX formula with parameters that can return values or tables. Parameters can be passed by value or by expressions. In this session, you learn how to define and consume user-defined functions in your semantic model.

Session Details

This session introduces the DAX Used-Defined Functions, the new feature announced in 2025!
A user-defined function is a DAX formula with parameters that can return values or tables. Parameters can be passed by value or by expressions. In this session, you learn how to define and consume user-defined functions in your semantic model.

3 things you'll get out of this session

- What are user-defined functions - How to create effective functions - Understand of functions are executed

Marco Russo's previous sessions

Unleash the full power of evaluation context manipulation, learn about expanded tables, control the data lineage, avoid circular dependencies, and manage relationships at different granularities.

Aggregations in Power BI

Introduce Power BI aggregations with practical examples, evaluate pros and cons, and learn how to use alternative approaches by using DAX to control the aggregation used.

Using ALLEXCEPT or ALL/VALUES?

Learn when to use ALL / VALUES instead of ALLEXCEPT in DAX calculations.

Understanding window functions in DAX

Introduction to DAX window functions and apply semantics through several examples to understand their capabilities and performance.