Marco Russo's Blog
View full profile
Welcome, Kurt Buhler!
I am glad to announce that Kurt Buhler has started to work with us at SQLBI – we just published his first article and video, Improving data labels with format strings. Now that the cat is out of the bag,… Read more

Where are Visual Calculations and DirectLake?
The right title for this blog post should be “Guidelines for SQLBI content publishing”, but it would be too boring. And, at the time of writing, the more common questions we receive about articles that are nowhere to be found… Read more

Announcing SQLBI Days: more options to improve your DAX knowledge!
At SQLBI, Alberto Ferrari and I spend most of our time sharing our knowledge and expertise in DAX. We have been doing this for years, navigating through conferences, workshops, and videos, encountering many individuals – from eager beginners to seasoned… Read more

What happened in the DAX world in 2023
Our end-of-the-year tradition is to recap what happened in the DAX and SQLBI world and look at what is coming next. Read more

New DirectQuery modules in the Optimizing DAX video course
The DirectQuery over SQL section of the Optimizing DAX video course is now available! In May 2023, we released the second edition of Optimizing DAX, which was completed for the first three sections: Core Concepts, Formula Engine, and VertiPaq. The… Read more

SqlBits 2024 Unveiled
If there is a conference you should attend at least once, it is SqlBits. Why? Because it is magic. It is impossible to imagine organizing such an international event with a team of volunteers. It is against common sense actually… Read more

SQLBI+ updates in July 2023
This month we published a second draft of the Window functions in DAX whitepaper for the SQLBI+ subscribers. After the first draft we published in January 2023, we added new sections and updated others. We completely rewrote the “apply semantics”… Read more

SQLBI+ updates in June 2023
This month we have a new video course and whitepaper for SQLBI+ subscribers: Inside Calculation Groups is available! This course is a deep dive into calculation groups in DAX. Although you might already be familiar with calculation groups, it is… Read more

Generative AI guidelines at SQLBI
These are pivotal times with the large adoption of new technologies like generative AI systems that will certainly impact how we work, along with a lot of other things. If you look at how Alberto and I answer questions related… Read more

Explaining REDUCED BY in xmSQL batch events
We recently released the second edition of the Optimizing DAX video course. Despite its volume, some details always did not find space in the training material. The REDUCED BY syntax of xmSQL is one of those details. Read more