Find the products in the top 10 every year with DAX

Don't miss the next newsletter - Subscribe now!

NEW ARTICLE

This article outlines the process of creating a measure to identify the top 10 products by sales each year.
Read more

SQLBI REPLAY

Differences between INT and CONVERT in DAX

This article describes the small differences between INT and CONVERT in DAX that may end up returning different results in arithmetic expressions.
Read more

COMICS

AI BI Blunders

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

#307 · Nov 2025

LEARNING

Course calendar

DATA MODELING - 3 DAYS

	Dec 2-4 - Amsterdam

Mastering DAX - 3 DAYS

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

While the list of courses scheduled for the first half of 2026 is already available, take advantage of the last two courses of 2025: prices will have to increase starting in January. Come attend Mastering DAX with Marco Russo in Chicago or Austin in 2025!

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.

» Chicago: November 12-14, 2025

» Austin: December 8-10, 2025

BI-WEEKLY NEWS DIGEST

Latest news

	• DAX Studio v3.4.0 The new version of DAX Studio supports user-defined functions and custom calendar: this is important for VertiPaq Analyzer, because if the model uses the new compatibility levels (1700+), then you need this version. Moreover, you can now export data in Parquet files! Oct 6, 2025 · Darren Gosbell
	• Direct Lake performance improvements for joins The indexes used by VertiPaq to join tables are now created in parallel for Direct Lake, thus reducing the latency when the users access for the first time a column that is not in memory. Nothing to learn here, just a signal that Direct Lake performance is reducing the gap with the faster Import mode (nope, not a typo). Oct 20, 2025 · Phil Seamark
	• Contributing to DaxLib If you haven't visited daxlib.org at this point, you should. If you also want to contribute, start from this article to understand how, depending on the type of the library you've written. Oct 22, 2025 · Jake Duddy
	• Automating Power BI load testing with Fabric Notebooks Not many model developers test the load performance of a report before publishing it. Automating the test could convince some more developers, or at least save time for the enlightened few. Oct 22, 2025 · Gilbert Quevauvilliers
	• DaxLib.SVG Watch out for the current state of development of the SVG library that everyone will be using in just a few months. You know, those nice sparklines in a matrix using an HTML measure: just call a function and you get it! Oct 24, 2025 · Jake Duddy

SQLBI YOUTUBE CHANNEL