The time has come: using AI to write DAX

Don't miss the next newsletter - Subscribe now!

NEW ARTICLE

The hidden complexity of a daily average in DAX

A DAX calculation can produce convincing values at the detail level and still fail at the total. The problem is often that the business rule was evaluated at the wrong granularity. This article introduces four grains, or levels of granularity, that should be identified before writing your DAX formula.
Read more

NEW VIDEO COURSES

The time has come: using AI to write DAX

In 2026, using AI to write DAX has started to be effective, as Marco Russo explains in Where we stand on AI and DAX in 2026.

We just released three new courses:

Latest news

	• Tabular Editor 2.29.0 A new version of the free Tabular Editor edition is available. Among other things, it includes improved support for DAX UDFs. Sep 11, 2026 · Daniel Otykier
	• Find what changed and when in your Power BI semantic model With a DAX query, you can inspect the change dates in a semantic model. Yes, you should have a Git repo and a proper deployment pipeline, but we know the real world isn't always ideal... Sep 13, 2026 · Chris Webb
	• Transition from ODBC to ADBC drivers in Power BI and Microsoft Fabric A means Arrow, and O is legacy here. Yes, a new driver family for Power BI and Fabric that performs better with HTTP connections. Must-read for awareness. Sep 14, 2026 · Microsoft
	• The query finished…Why is my Fabric SQL database still consuming CUs? Yep, that query running in 2 seconds doesn't really bill for only 2 seconds! Sep 16, 2026 · Nikola Ilic
	• Deneb 2.0 Released While we don't focus much on the reporting layer here, Deneb is a welcome exception: a visual for building many visualizations. Coming soon to AppSource. Sep 8, 2026 · Daniel Marsh-Patrick

DAX with AI new courses launch - 20% OFF on single courses - 32% OFF on bundle!

SQLBI YOUTUBE CHANNEL

Latest videos

Writing DAX at the correct granularity