SQLBI Newsletter #329

Don't miss the next newsletter - Subscribe now!

NEW ARTICLE

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

COMICS

AI BI Blunders

This comic has been generated by Grok and ChatGPT using so many prompts...

CLASSROOM COURSES IN 2026

Attend the new in-person Mastering DAX

We are only offering five Mastering DAX classroom courses until the end of 2026, so make sure to get your seat:

North America & United Kingdom

Europe

We continue to update our in-person training with the latest news, new exercises, and you will get full access to the video course as soon as your seat is confirmed!

#329 · Sep 2026

LEARNING

Course calendar

DATA MODELING - 3 DAYS

Mastering DAX - 3 DAYS

	Oct 12-14 - Warsaw
	Oct 27-29 - Lugano
	Nov 9-11 - Atlanta
	Nov 24-26 - London
	Dec 1-3 - Amsterdam

video courses

	Introducing DAX
	Mastering DAX
	Optimizing DAX
	Intro to Data Modeling
	Data Modeling for Power BI
	Mastering Tabular
	DAX Tools Video Course
	DAX Patterns
	Power BI Dashboard Design

BI-WEEKLY NEWS DIGEST

Latest news

	• DAX Studio 3.6.1 Fixes needed after the big 3.6.0 release, which introduced Delta Analyzer for OneLake. Aug 23, 2026 · Darren Gosbell
	• The XMLA endpoint for Power BI: how it works and how to use it If you need to clarify the differences between XMLA endpoint and REST API, this is the article to read. Spoiler: XMLA endpoint is here to stay. Aug 26, 2026 · Ruben Van de Voorde
	• Power BI calculation groups just got faster to compile We don't like AI-generated articles, but when the alternative is not having the information, we can make an exception! Calculation groups optimization is an area we have to investigate more; for now check out the optimization implemented by Microsoft. Sep 2, 2026 · Phil Seamark
	• Introducing Excel semantic table add-in First, the add-in linked to this article has several bugs and hopefully it will improve. However, it's the tool that Excel users had been dreaming of for many years: being able to query a Power BI semantic model using a table and not a matrix, without having to restart from scratch for every change... Like we have to with the Microsoft "Insert table" option. Aug 30, 2026 · Teo Lachev

Stop guessing DAX. Start mastering it with Mastering DAX Video Course 3rd Edition.

SQLBI YOUTUBE CHANNEL

Latest videos

Testing DAX measures by using AI