SQLBI Newsletter #316

Don't miss the next newsletter - Subscribe now!

NEW ARTICLE

Creating functions for the like-for-like DAX pattern

Learn how to transform the like-for-like pattern into a model-independent function so you can easily reuse it.
Read more

NEW POST

SQLBI+ updates in March 2026

We released new content for SQLBI+ subscribers: Understanding Visual Calculations in DAX is now a video course that also includes the final version of the whitepaper which we had previously released in draft versions.
Read more

COMICS

AI BI Blunders

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

COURSES IN 2026

Houston and New York City: last call!

Book your seat to the new Mastering DAX classroom course, which is now updated with user-defined functions and calendar-based time intelligence. Houston and New York City are approaching fast, so make sure to book you seat soon!
Read more

#316 · Mar 2026

LEARNING

Course calendar

DATA MODELING - 3 DAYS

	Jul 21-23 - Amsterdam

Mastering DAX - 3 DAYS

	Mar 30-Apr 1 - Houston
	Apr 8-10 - New York City
	May 5-7 - Copenhagen
	May 27-29 - Baltimore
	Jun 10-12 - Zürich
	Jun 15-17 - Berlin
	Jun 30-Jul 2 - 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

	• Power BI February 2024 updates Just a new function, TABLEOF, which will simplify DAX libraries. Many deprecated features. A new set of defaults for core visuals in preview. This is just an appetizer for March, right? We look forward to bigger news with Fabcon right around the corner (next week!). Feb 24, 2026 · Microsoft
	• On-premises data gateway (almost) automatic updates We missed a big piece of news a few months ago. With the latest data gateway, you can update the gateway from the Fabric or Power BI portal without logging into the server that hosts the gateway! How did we miss that!??!?! Oct 29, 2025 · Microsoft
	• The AI-Enabled Power BI Tester You needed tests before AI, you need more tests with AI. This article introduces testing patterns and a library of DAX UDFs that make it easier to implement and run these tests also for AI. Feb 22, 2026 · John Kerski
	• Direct Lake composite models Here is a lesson learned by using Direct Lake "only" and Direct Lake composite models that mix Import and Direct Lake modes. Mar 4, 2026 · Teo Lachev
	• Tabular Editor 2.28 This is more a maintenance release, but if you use Tabular Editor 2, you should upgrade to align with the latest TOM libraries and compatibility levels for semantic models. Mar 2, 2026 · Daniel Otykier
	• AE Power BI Multi-Tool 2.0 This tool offers several interesting features to manipulate reports saved in PBIP format: cleanup, sensitivity scanner, layout optimizer, report merger, copy tool, and more. If you are a consultant delivering reports to customers, you definitely want to take a look at this. Jan 31, 2026 · Analytic Endeavors

SQLBI YOUTUBE CHANNEL