Using VALUES in SUMMARIZE - SQLBI Newsletter #306

Don't miss the next newsletter - Subscribe now!

NEW ARTICLE

This article describes when to use VALUES in a table grouped by SUMMARIZE, then goes on to explain why you cannot however use VALUES with SUMMARIZECOLUMNS.
Read more

SQLBI REPLAY

Using cross-highlight with order and delivery dates in Power BI

This article describes how to enable the cross-highlight in Power BI charts using different dates for the same event, such as Order Date and Delivery Date.
Read more

COMICS

AI BI Blunders

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

#306 · Oct 2025

LEARNING

Course calendar

DATA MODELING - 3 DAYS

	Dec 2-4 - Amsterdam

Mastering DAX - 3 DAYS

	Oct 28-30 - Lugano
	Nov 4-6 - Amsterdam
	Nov 12-14 - Chicago
	Dec 8-10 - Austin

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

CLASSROOM COURSES

Mastering DAX in Chicago & Austin

We are offering only two more classroom courses in the United States in 2025: Chicago and Austin, both with Marco Russo!

The goal of these three-day, classroom courses is for the expert trainer to teach all the features of the DAX language, providing the knowledge to write formulas for common and advanced business scenarios. The course includes an overview of the new Calendar feature and the User-defined functions (UDF) in DAX! All the attendees will receive a copy of the e-book, The Definitive Guide to DAX.

Come join Marco before seats run out!
These are our last US courses before the end of the year!

» Chicago: November 12-14, 2025

» Austin: December 8-10, 2025

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI October 2025 updates While this release does not have new features for the semantic model, it's a mandatory update for DAX user-defined functions and calendar-based time intelligence: after a big new release, it is normal to get many fixes. Do not forget to update frequently if you use these new features! Sep 16, 2025 · Microsoft
	• Deep dive into composite semantic models with Direct Lake and import tables You can now use the web editor in Power BI Service to import tables in a model that uses DirectLake. This makes it easier to enable the DirectLake+Import scenario we described in May. The article also includes other news on the web experience, like the availability of Performance Analyzer. Oct 6, 2025 · Microsoft
	• Deprecation of Metric Sets in Power BI Less than a year after its launch in preview, Microsoft deprecated the Metric Sets. As it happens, we never mentioned this feature in this newsletter or in our articles. Someone who properly selects exactly what news to share can save you time... Oct 6, 2025 · Microsoft
	• Visit daxlib.org to view, try, and publish public, open-source UDFs in DAX! Visit daxlib.org to find the ever-increasing number of DAX libraries already available. We are working to improve the website, the community is publishing new libraries, you just have to use them! Sep 16, 2025 · SQLBI

SQLBI YOUTUBE CHANNEL