DAX

3 posts on DAX: benchmarks, internals and workarounds for the Microsoft data stack.

1. 03
   DAX User Defined Functions (Preview)

   How DAX user defined functions work: declaring UDFx with DEFINE and FUNCTION, val versus expr parameters, and where they hold up in a real model.

   Sep 21, 2025
2. 02
   Stop Repeating CALCULATE: Iterate Over Categories in DAX

   Stop repeating CALCULATE in your DAX. Discover how to iterate and simplify category-level logic with SUMX, AVERAGEX, and virtual tables like VALUES and SUMMARIZE.

   Jun 30, 2025
3. 01
   Top everyday DAX functions

   The DAX functions worth learning first and what each one is actually for. Not a reference list: the handful you end up using in every model.

   Feb 18, 2025