SQLBI Newsletter #322

Don't miss the next newsletter - Subscribe now!

NEW ARTICLE

ALL vs ALLSELECTED vs ALLEXCEPT vs REMOVEFILTERS

DAX offers several functions to remove filters from the filter context. This article analyzes the differences among them and clarifies what to use depending on the requirements.
Read more

COMICS

AI BI Blunders

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

CLASSROOM COURSES IN 2026

Back to Atlanta

We are happy to announce that we will be back in Atlanta in November! This is the only date left in the US for 2026.

We also added London and Lugano in Europe, but before summer there are still seats available in Zürich and Amsterdam! In Amsterdam you also have a date for Data Modeling.

#322 · Jun 2026

LEARNING

Course calendar

DATA MODELING - 3 DAYS

	Jul 21-23 - Amsterdam

Mastering DAX - 3 DAYS

	Jun 10-12 - Zürich
	Jun 15-17 - Berlin
	Jun 30-Jul 2 - Amsterdam
	Oct 27-29 - Lugano
	Nov 9-11 - Atlanta
	Nov 24-26 - London

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

Built for any space you manage - Synoptic Panel for Power BI by OKVIZ

BI-WEEKLY NEWS DIGEST

Latest news

	• Card with States The new version of the free "Card with States by OKVIZ" custom visual is available and is also certified! Do not miss the ability to improve your reports with minimal effort. May 20, 2026 · OKVIZ
	• Power BI May 2026 updates Several features moved from preview to GA. A few improvements. No news, good news: we can continue to play with the latest LLMs until next month. May 19, 2026 · Microsoft
	• Deep dive into joins in Power Query This two-part series explores all the joins available in Power Query (M). They are similar, but not identical, to the options you have in SQL. Very good refresher even if you think to already know the topic. May 5, 2026 · Ben Gribaudo
	• New Power Query experience in Power BI Desktop Finally, the Power Query user interface in Power BI Desktop is now aligned with the feature in Fabric and Power BI service. Still in preview, though. May 20, 2026 · Microsoft

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

SQLBI YOUTUBE CHANNEL

Latest videos

Introducing user-aware calculated columns in Power BI