SQLBI Newsletter #323

Don't miss the next newsletter - Subscribe now!

NEW ARTICLE

Optional parameters in DAX user-defined functions

This article describes how to define optional parameters in DAX user-defined functions and set default values for parameters not specified by the caller.
Read more

COMICS

AI BI Blunders

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

CLASSROOM COURSES IN 2026

Last seats before summer

We have only two in-person courses in Amsterdam before summer:

We published all the in-person courses for the second half of 2026: do not wait, register early!

#322 · Jun 2026

LEARNING

Course calendar

DATA MODELING - 3 DAYS

	Jul 21-23 - Amsterdam

Mastering DAX - 3 DAYS

	Jun 15-17 - Berlin
	Jun 30-Jul 2 - Amsterdam
	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

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

BI-WEEKLY NEWS DIGEST

Latest news

	• DAX User-Defined Functions are generally available No more excuses: whether you use one of the 50+ libraries available at daxlib.org or write your own functions, you must start now. Jun 6, 2026 · Microsoft
	• Power BI June 2026 updates Beside UDFs, the more relevant releases are tools for AI covered in the following news. Read the announcement: it's no longer "just" Copilot anymore. The MCP Server for the semantic model was just the beginning. Jun 9, 2026 · Microsoft
	• Fabric Apps explained One of the Microsoft announcements of the June 2026 release is Fabric App. However, the best example is in an article from Kurt Buhler. Yes, you can do more than a dashboard in a Fabric App, but it is the obvious starting point. Jun 3, 2026 · Kurt Buhler
	• Power BI Authoring plugin for AI Microsoft released skills and tools to vibe code a Power BI report and not only the semantic model. Pay attention: this is not the usual Copilot hype, it can work with your preferred LLM. Jun 8, 2026 · Microsoft
	• PBIR Tools If you want to enter the world of Power BI agentic development, you should also try PBIR Tools. The world is changing fast: do not limit your curiosity to what Microsoft pushes out. Jun 13, 2026 · Maxim Anatsko

SQLBI YOUTUBE CHANNEL

Latest videos

ALL vs ALLSELECTED vs ALLEXCEPT vs REMOVEFILTERS