Marco Russo
@marcorus.bsky.social
Consultant, speaker, book writer, mentor. Business Intelligence with Power BI, Analysis Services, and Power Pivot. Other info on sqlbi.com
This article+video shows how to create a DAX measure that displays information from multiple columns in a transaction into a single column of a matrix.
Showing more in less space!
#powerbi #dax
https://www.sqlbi.com/articles/show-transaction-details-on-the-matrix-visual-in-power-bi/
Showing more in less space!
#powerbi #dax
https://www.sqlbi.com/articles/show-transaction-details-on-the-matrix-visual-in-power-bi/
January 27, 2026 at 11:03 AM
This article+video shows how to create a DAX measure that displays information from multiple columns in a transaction into a single column of a matrix.
Showing more in less space!
#powerbi #dax
https://www.sqlbi.com/articles/show-transaction-details-on-the-matrix-visual-in-power-bi/
Showing more in less space!
#powerbi #dax
https://www.sqlbi.com/articles/show-transaction-details-on-the-matrix-visual-in-power-bi/
Power BI Desktop is showing black icons for many users due to a WebView2 regression. I wrote a short article explaining the issue and a safe workaround.
https://www.sqlbi.com/blog/marco/2026/01/24/fixing-the-black-icons-issue-in-power-bi-desktop-understanding-the-problem-and-a-temporary-workaround/
https://www.sqlbi.com/blog/marco/2026/01/24/fixing-the-black-icons-issue-in-power-bi-desktop-understanding-the-problem-and-a-temporary-workaround/
January 24, 2026 at 1:50 PM
Power BI Desktop is showing black icons for many users due to a WebView2 regression. I wrote a short article explaining the issue and a safe workaround.
https://www.sqlbi.com/blog/marco/2026/01/24/fixing-the-black-icons-issue-in-power-bi-desktop-understanding-the-problem-and-a-temporary-workaround/
https://www.sqlbi.com/blog/marco/2026/01/24/fixing-the-black-icons-issue-in-power-bi-desktop-understanding-the-problem-and-a-temporary-workaround/
"It depends" is the only 100% accurate answer in Business Intelligence.
What is your “it depends” KPI?
This comic from SQLBI Newsletter #311: https://www.sqlbi.com/nl/v/2444/
What is your “it depends” KPI?
This comic from SQLBI Newsletter #311: https://www.sqlbi.com/nl/v/2444/
January 24, 2026 at 9:03 AM
"It depends" is the only 100% accurate answer in Business Intelligence.
What is your “it depends” KPI?
This comic from SQLBI Newsletter #311: https://www.sqlbi.com/nl/v/2444/
What is your “it depends” KPI?
This comic from SQLBI Newsletter #311: https://www.sqlbi.com/nl/v/2444/
News about The Definitive Guide to DAX, Third Edition.
𝗖𝗵𝗮𝗽𝘁𝗲𝗿 𝟯 is available as a 𝗳𝗿𝗲𝗲 𝘀𝗮𝗺𝗽𝗹𝗲 (𝗶𝗻 𝗣𝗗𝗙).
The 𝗽𝗿𝗶𝗻𝘁𝗲𝗱 𝘃𝗲𝗿𝘀𝗶𝗼𝗻 of the book is now available on Amazon in the United States, Canada, and Mexico for 𝗶𝗺𝗺𝗲𝗱𝗶𝗮𝘁𝗲 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴.
https://www.sqlbi.com/books/the-definitive-guide-to-dax-third-edition/
𝗖𝗵𝗮𝗽𝘁𝗲𝗿 𝟯 is available as a 𝗳𝗿𝗲𝗲 𝘀𝗮𝗺𝗽𝗹𝗲 (𝗶𝗻 𝗣𝗗𝗙).
The 𝗽𝗿𝗶𝗻𝘁𝗲𝗱 𝘃𝗲𝗿𝘀𝗶𝗼𝗻 of the book is now available on Amazon in the United States, Canada, and Mexico for 𝗶𝗺𝗺𝗲𝗱𝗶𝗮𝘁𝗲 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴.
https://www.sqlbi.com/books/the-definitive-guide-to-dax-third-edition/
January 21, 2026 at 12:03 PM
News about The Definitive Guide to DAX, Third Edition.
𝗖𝗵𝗮𝗽𝘁𝗲𝗿 𝟯 is available as a 𝗳𝗿𝗲𝗲 𝘀𝗮𝗺𝗽𝗹𝗲 (𝗶𝗻 𝗣𝗗𝗙).
The 𝗽𝗿𝗶𝗻𝘁𝗲𝗱 𝘃𝗲𝗿𝘀𝗶𝗼𝗻 of the book is now available on Amazon in the United States, Canada, and Mexico for 𝗶𝗺𝗺𝗲𝗱𝗶𝗮𝘁𝗲 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴.
https://www.sqlbi.com/books/the-definitive-guide-to-dax-third-edition/
𝗖𝗵𝗮𝗽𝘁𝗲𝗿 𝟯 is available as a 𝗳𝗿𝗲𝗲 𝘀𝗮𝗺𝗽𝗹𝗲 (𝗶𝗻 𝗣𝗗𝗙).
The 𝗽𝗿𝗶𝗻𝘁𝗲𝗱 𝘃𝗲𝗿𝘀𝗶𝗼𝗻 of the book is now available on Amazon in the United States, Canada, and Mexico for 𝗶𝗺𝗺𝗲𝗱𝗶𝗮𝘁𝗲 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴.
https://www.sqlbi.com/books/the-definitive-guide-to-dax-third-edition/
This article analyzes the performance of regular versus limited relationships in DAX to understand the implications of using limited relationships.
#powerbi #dax #optimization
https://www.sqlbi.com/articles/analyzing-the-performance-of-limited-and-regular-relationships/
#powerbi #dax #optimization
https://www.sqlbi.com/articles/analyzing-the-performance-of-limited-and-regular-relationships/
January 13, 2026 at 11:03 AM
This article analyzes the performance of regular versus limited relationships in DAX to understand the implications of using limited relationships.
#powerbi #dax #optimization
https://www.sqlbi.com/articles/analyzing-the-performance-of-limited-and-regular-relationships/
#powerbi #dax #optimization
https://www.sqlbi.com/articles/analyzing-the-performance-of-limited-and-regular-relationships/
There are two types of people after a breakup:
those who talk to their friends, and those who open DAX Studio.
If your data model could give you life advice, what would it be?
those who talk to their friends, and those who open DAX Studio.
If your data model could give you life advice, what would it be?
January 10, 2026 at 8:31 AM
There are two types of people after a breakup:
those who talk to their friends, and those who open DAX Studio.
If your data model could give you life advice, what would it be?
those who talk to their friends, and those who open DAX Studio.
If your data model could give you life advice, what would it be?
𝗕𝗼𝗼𝗸 𝘂𝗽𝗱𝗮𝘁𝗲: The third edition of *The Definitive Guide to DAX* is available in all formats.
The 𝗞𝗶𝗻𝗱𝗹𝗲 version experienced 𝗾𝘂𝗮𝗹𝗶𝘁𝘆 𝗶𝘀𝘀𝘂𝗲𝘀. If you bought it, you have 7 days to request a refund.
Read more in the FAQ: https://www.sqlbi.com/books/the-definitive-guide-to-dax-third-edition/
The 𝗞𝗶𝗻𝗱𝗹𝗲 version experienced 𝗾𝘂𝗮𝗹𝗶𝘁𝘆 𝗶𝘀𝘀𝘂𝗲𝘀. If you bought it, you have 7 days to request a refund.
Read more in the FAQ: https://www.sqlbi.com/books/the-definitive-guide-to-dax-third-edition/
December 20, 2025 at 11:17 AM
𝗕𝗼𝗼𝗸 𝘂𝗽𝗱𝗮𝘁𝗲: The third edition of *The Definitive Guide to DAX* is available in all formats.
The 𝗞𝗶𝗻𝗱𝗹𝗲 version experienced 𝗾𝘂𝗮𝗹𝗶𝘁𝘆 𝗶𝘀𝘀𝘂𝗲𝘀. If you bought it, you have 7 days to request a refund.
Read more in the FAQ: https://www.sqlbi.com/books/the-definitive-guide-to-dax-third-edition/
The 𝗞𝗶𝗻𝗱𝗹𝗲 version experienced 𝗾𝘂𝗮𝗹𝗶𝘁𝘆 𝗶𝘀𝘀𝘂𝗲𝘀. If you bought it, you have 7 days to request a refund.
Read more in the FAQ: https://www.sqlbi.com/books/the-definitive-guide-to-dax-third-edition/
This article+video describes the data model and DAX measures to analyze campaign effectiveness 𝗮𝗻𝗮𝗹𝘆𝘇𝗲 𝗰𝗮𝗺𝗽𝗮𝗶𝗴𝗻 𝗲𝗳𝗳𝗲𝗰𝘁𝗶𝘃𝗲𝗻𝗲𝘀𝘀 by separating 𝗮𝘁𝘁𝗿𝗶𝗯𝘂𝘁𝗲𝗱 𝘀𝗮𝗹𝗲𝘀 from 𝗶𝗻𝗳𝗹𝘂𝗲𝗻𝗰𝗲𝗱 𝘀𝗮𝗹𝗲𝘀.
#dax #powerbi
https://www.sqlbi.com/articles/measuring-the-impact-of-promotions-on-sales-in-power-bi/
#dax #powerbi
https://www.sqlbi.com/articles/measuring-the-impact-of-promotions-on-sales-in-power-bi/
December 16, 2025 at 11:02 AM
This article+video describes the data model and DAX measures to analyze campaign effectiveness 𝗮𝗻𝗮𝗹𝘆𝘇𝗲 𝗰𝗮𝗺𝗽𝗮𝗶𝗴𝗻 𝗲𝗳𝗳𝗲𝗰𝘁𝗶𝘃𝗲𝗻𝗲𝘀𝘀 by separating 𝗮𝘁𝘁𝗿𝗶𝗯𝘂𝘁𝗲𝗱 𝘀𝗮𝗹𝗲𝘀 from 𝗶𝗻𝗳𝗹𝘂𝗲𝗻𝗰𝗲𝗱 𝘀𝗮𝗹𝗲𝘀.
#dax #powerbi
https://www.sqlbi.com/articles/measuring-the-impact-of-promotions-on-sales-in-power-bi/
#dax #powerbi
https://www.sqlbi.com/articles/measuring-the-impact-of-promotions-on-sales-in-power-bi/
Should you use RANK or stick with RANKX?
In which scenarios is one better than the other?
Make an informed choice with this article + video!
#powerbi #dax
https://www.sqlbi.com/articles/using-rank-instead-of-rankx-in-dax/
In which scenarios is one better than the other?
Make an informed choice with this article + video!
#powerbi #dax
https://www.sqlbi.com/articles/using-rank-instead-of-rankx-in-dax/
December 2, 2025 at 11:04 AM
Should you use RANK or stick with RANKX?
In which scenarios is one better than the other?
Make an informed choice with this article + video!
#powerbi #dax
https://www.sqlbi.com/articles/using-rank-instead-of-rankx-in-dax/
In which scenarios is one better than the other?
Make an informed choice with this article + video!
#powerbi #dax
https://www.sqlbi.com/articles/using-rank-instead-of-rankx-in-dax/
If you are at PASS Summit 2025, look for me at the Tabular Editor booth in the Exhibit Hall.
I will show a sneak preview of DAX Optimizer basic edition: no emails, no data access, no external tools required.
The easiest way to verify if your semantic model can be optimized.
Coming soon...
I will show a sneak preview of DAX Optimizer basic edition: no emails, no data access, no external tools required.
The easiest way to verify if your semantic model can be optimized.
Coming soon...
November 19, 2025 at 5:22 PM
If you are at PASS Summit 2025, look for me at the Tabular Editor booth in the Exhibit Hall.
I will show a sneak preview of DAX Optimizer basic edition: no emails, no data access, no external tools required.
The easiest way to verify if your semantic model can be optimized.
Coming soon...
I will show a sneak preview of DAX Optimizer basic edition: no emails, no data access, no external tools required.
The easiest way to verify if your semantic model can be optimized.
Coming soon...
Learn the differences between model-dependent and model-independent DAX user-defined functions in this article+video.
Bonus: tips to publish libraries of functions on daxlib.org.
#dax #powerbi
https://www.sqlbi.com/articles/model-dependent-and-model-independent-user-defined-functions-in-dax/
Bonus: tips to publish libraries of functions on daxlib.org.
#dax #powerbi
https://www.sqlbi.com/articles/model-dependent-and-model-independent-user-defined-functions-in-dax/
November 18, 2025 at 11:03 AM
Learn the differences between model-dependent and model-independent DAX user-defined functions in this article+video.
Bonus: tips to publish libraries of functions on daxlib.org.
#dax #powerbi
https://www.sqlbi.com/articles/model-dependent-and-model-independent-user-defined-functions-in-dax/
Bonus: tips to publish libraries of functions on daxlib.org.
#dax #powerbi
https://www.sqlbi.com/articles/model-dependent-and-model-independent-user-defined-functions-in-dax/
Top 10 products are a classic. Reporting which products are in the top 10 for several years is more challenging.
We are looking for 𝗲𝘃𝗲𝗿𝗴𝗿𝗲𝗲𝗻 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝘀: how to find them in DAX in this article+video.
#powerbi #dax
https://www.sqlbi.com/articles/find-the-products-in-the-top-10-every-year-with-dax/
We are looking for 𝗲𝘃𝗲𝗿𝗴𝗿𝗲𝗲𝗻 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝘀: how to find them in DAX in this article+video.
#powerbi #dax
https://www.sqlbi.com/articles/find-the-products-in-the-top-10-every-year-with-dax/
November 4, 2025 at 11:04 AM
Top 10 products are a classic. Reporting which products are in the top 10 for several years is more challenging.
We are looking for 𝗲𝘃𝗲𝗿𝗴𝗿𝗲𝗲𝗻 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝘀: how to find them in DAX in this article+video.
#powerbi #dax
https://www.sqlbi.com/articles/find-the-products-in-the-top-10-every-year-with-dax/
We are looking for 𝗲𝘃𝗲𝗿𝗴𝗿𝗲𝗲𝗻 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝘀: how to find them in DAX in this article+video.
#powerbi #dax
https://www.sqlbi.com/articles/find-the-products-in-the-top-10-every-year-with-dax/
Today you have one task: update DAX Studio to 3.4.0.
If you have a model with DAX UDFs (user-defined functions) or Calendars, here is the version that correctly handles autocompletion and VPAX export.
𝗘𝘅𝗽𝗼𝗿𝘁 𝘁𝗼 𝗣𝗮𝗿𝗾𝘂𝗲𝘁? Now you can!
https://daxstudio.org/blog/v3_4_0-release/
If you have a model with DAX UDFs (user-defined functions) or Calendars, here is the version that correctly handles autocompletion and VPAX export.
𝗘𝘅𝗽𝗼𝗿𝘁 𝘁𝗼 𝗣𝗮𝗿𝗾𝘂𝗲𝘁? Now you can!
https://daxstudio.org/blog/v3_4_0-release/
October 24, 2025 at 6:46 AM
Today you have one task: update DAX Studio to 3.4.0.
If you have a model with DAX UDFs (user-defined functions) or Calendars, here is the version that correctly handles autocompletion and VPAX export.
𝗘𝘅𝗽𝗼𝗿𝘁 𝘁𝗼 𝗣𝗮𝗿𝗾𝘂𝗲𝘁? Now you can!
https://daxstudio.org/blog/v3_4_0-release/
If you have a model with DAX UDFs (user-defined functions) or Calendars, here is the version that correctly handles autocompletion and VPAX export.
𝗘𝘅𝗽𝗼𝗿𝘁 𝘁𝗼 𝗣𝗮𝗿𝗾𝘂𝗲𝘁? Now you can!
https://daxstudio.org/blog/v3_4_0-release/
This article+video describes when to use VALUES in the table grouped by SUMMARIZE, also mentioning why SUMMARIZECOLUMNS does not have that option.
#powerbi #dax
https://www.sqlbi.com/articles/using-values-in-summarize/
#powerbi #dax
https://www.sqlbi.com/articles/using-values-in-summarize/
October 21, 2025 at 10:04 AM
This article+video describes when to use VALUES in the table grouped by SUMMARIZE, also mentioning why SUMMARIZECOLUMNS does not have that option.
#powerbi #dax
https://www.sqlbi.com/articles/using-values-in-summarize/
#powerbi #dax
https://www.sqlbi.com/articles/using-values-in-summarize/
Simon Sabin and I sit down and chat to answer one simple question: why bother with conferences in 2026?
In the chat, we talk about meeting peers, asking real questions, and learning from battle-tested content (not vendor demos).
Watch (or just listen to) the video:
https://youtu.be/zwGDfL-B3jQ
In the chat, we talk about meeting peers, asking real questions, and learning from battle-tested content (not vendor demos).
Watch (or just listen to) the video:
https://youtu.be/zwGDfL-B3jQ
September 27, 2025 at 7:34 AM
Simon Sabin and I sit down and chat to answer one simple question: why bother with conferences in 2026?
In the chat, we talk about meeting peers, asking real questions, and learning from battle-tested content (not vendor demos).
Watch (or just listen to) the video:
https://youtu.be/zwGDfL-B3jQ
In the chat, we talk about meeting peers, asking real questions, and learning from battle-tested content (not vendor demos).
Watch (or just listen to) the video:
https://youtu.be/zwGDfL-B3jQ
I will be delivering a "Mastering DAX" Workshop in Lugano, Switzerland, from October 28-30, 2025.
This workshop is also near Northern Italy, France, and Southern Germany.
The workshop is in English.
For more details, visit: https://www.sqlbi.com/p/mastering-dax-workshop-lugano-oct-28-30-2025/
This workshop is also near Northern Italy, France, and Southern Germany.
The workshop is in English.
For more details, visit: https://www.sqlbi.com/p/mastering-dax-workshop-lugano-oct-28-30-2025/
September 25, 2025 at 8:31 AM
I will be delivering a "Mastering DAX" Workshop in Lugano, Switzerland, from October 28-30, 2025.
This workshop is also near Northern Italy, France, and Southern Germany.
The workshop is in English.
For more details, visit: https://www.sqlbi.com/p/mastering-dax-workshop-lugano-oct-28-30-2025/
This workshop is also near Northern Italy, France, and Southern Germany.
The workshop is in English.
For more details, visit: https://www.sqlbi.com/p/mastering-dax-workshop-lugano-oct-28-30-2025/
We finally have 𝘂𝘀𝗲𝗿-𝗱𝗲𝗳𝗶𝗻𝗲𝗱 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀 (𝗨𝗗𝗙) in DAX!
Don't make mistakes; this is not a user data function in Fabric.
This is a new DAX feature, the most important one in the last five years.
Read/watch more:
https://www.sqlbi.com/articles/introducing-user-defined-functions-in-dax/
Don't make mistakes; this is not a user data function in Fabric.
This is a new DAX feature, the most important one in the last five years.
Read/watch more:
https://www.sqlbi.com/articles/introducing-user-defined-functions-in-dax/
September 16, 2025 at 9:11 AM
We finally have 𝘂𝘀𝗲𝗿-𝗱𝗲𝗳𝗶𝗻𝗲𝗱 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀 (𝗨𝗗𝗙) in DAX!
Don't make mistakes; this is not a user data function in Fabric.
This is a new DAX feature, the most important one in the last five years.
Read/watch more:
https://www.sqlbi.com/articles/introducing-user-defined-functions-in-dax/
Don't make mistakes; this is not a user data function in Fabric.
This is a new DAX feature, the most important one in the last five years.
Read/watch more:
https://www.sqlbi.com/articles/introducing-user-defined-functions-in-dax/
Read our first article and watch the video about the new calendar-based time intelligence feature in DAX and Power BI.
Helpful for Gregorian, necessary for non-Gregorian calendars.
#powerbi #dax #timeintelligence
https://www.sqlbi.com/articles/introducing-calendar-based-time-intelligence-in-dax/
Helpful for Gregorian, necessary for non-Gregorian calendars.
#powerbi #dax #timeintelligence
https://www.sqlbi.com/articles/introducing-calendar-based-time-intelligence-in-dax/
September 16, 2025 at 8:26 AM
Read our first article and watch the video about the new calendar-based time intelligence feature in DAX and Power BI.
Helpful for Gregorian, necessary for non-Gregorian calendars.
#powerbi #dax #timeintelligence
https://www.sqlbi.com/articles/introducing-calendar-based-time-intelligence-in-dax/
Helpful for Gregorian, necessary for non-Gregorian calendars.
#powerbi #dax #timeintelligence
https://www.sqlbi.com/articles/introducing-calendar-based-time-intelligence-in-dax/
Introducing AI and Agentic Development for Power BI: an article that explores concepts and scenarios for integrating AI and AI agents into BI development, with specific examples for Power BI.
https://www.sqlbi.com/articles/introducing-ai-and-agentic-development-for-business-intelligence/
https://www.sqlbi.com/articles/introducing-ai-and-agentic-development-for-business-intelligence/
September 9, 2025 at 10:03 AM
Introducing AI and Agentic Development for Power BI: an article that explores concepts and scenarios for integrating AI and AI agents into BI development, with specific examples for Power BI.
https://www.sqlbi.com/articles/introducing-ai-and-agentic-development-for-business-intelligence/
https://www.sqlbi.com/articles/introducing-ai-and-agentic-development-for-business-intelligence/
Yes, you can use SUMMARIZECOLUMNS in a DAX measure, BUT...
But only if you follow the best practices in this article + video.
Spoiler: Goodbye ADDCOLUMNS / SUMMARIZE - well, with some exceptions...
#dax #powerbi
https://www.sqlbi.com/articles/summarizecolumns-best-practices/
But only if you follow the best practices in this article + video.
Spoiler: Goodbye ADDCOLUMNS / SUMMARIZE - well, with some exceptions...
#dax #powerbi
https://www.sqlbi.com/articles/summarizecolumns-best-practices/
August 12, 2025 at 10:02 AM
Yes, you can use SUMMARIZECOLUMNS in a DAX measure, BUT...
But only if you follow the best practices in this article + video.
Spoiler: Goodbye ADDCOLUMNS / SUMMARIZE - well, with some exceptions...
#dax #powerbi
https://www.sqlbi.com/articles/summarizecolumns-best-practices/
But only if you follow the best practices in this article + video.
Spoiler: Goodbye ADDCOLUMNS / SUMMARIZE - well, with some exceptions...
#dax #powerbi
https://www.sqlbi.com/articles/summarizecolumns-best-practices/