Marco Russo's Blog posts of 2023

11 results

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

SQLBI+ updates in March 2023

At the end of March, we released the second update of SQLBI+ with a new session about different types of many-to-many relationships in DAX. The goal is to explain the difference between the many-to-many cardinality relationship available in Power BI…  Read more

Behind the scenes of an April Fools’ Day

Yesterday we published an April Fool: Navigating the Data Ecosystem: A Revolutionary Analytics Architecture. The idea of writing a piece about a new architecture that could immediately make the latest cool buzzwords obsolete rounded my mind for a few weeks.…  Read more

SQLBI+ updates in January 2023

After the SQLBI+ launch in November 2022, we released the first update with additional content: two sessions about Time Intelligence and one whitepaper about the new DAX window functions. This is much more than the single Time Intelligence session we…  Read more