Marco Russo's Blog
View full profileGenerative 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
Creating database aliases on SQL Server 2022
If you create server aliases for SQL Server connections, you should be aware of the changes introduced in SQL Server 2022. At SQLBI we use aliases to identify the server’s name in the connection of our sample files (Power BI… Read more
What happened in the DAX world in 2022
Here we are, at the end of another year, to see what happened in the DAX world. Read more
Fixing incorrect dictionary size reported by VertiPaq Analyzer
There are cases where the dictionary size reported by VertiPaq Analyzer (used by DAX Studio, Bravo for Power BI, and Tabular Editor 3) does not correspond to the actual memory required by the dictionary. However, the number reported is technically… Read more
DAX Studio 3 released!
DAX Studio 3 was released today. This new, major version offers a new user interface and user experience, providing a modern look and feel without losing any of the features available in previous versions. On the contrary, in DAX Studio… Read more
Different filter behaviors in SUMMARIZECOLUMNS and CALCULATETABLE
We recently updated SUMMARIZECOLUMNS on DAX Guide by adding an example that clarifies the difference between a filter applied to SUMMARIZECOLUMNS and a filter applied to CALCULATETABLE. Most of the times, you can move a filter from a SUMMARIZECOLUMNS argument… Read more