This article+video describes the parameter types available in DAX user-defined functions, focusing on the specialized reference types MEASUREREF, COLUMNREF, TABLEREF, and CALENDARREF.
#dax #powerbi
www.sqlbi.com/articles/understanding-p...
Posts by Marco Russo
LOL ๐
You can always slow it down with 5% steps, unless you have a pridewall ๐
It should be the same technique!
Visual calculations can be used efficiently to format visuals. This article and video present an interesting technique to highlight a row based solely on the maximum value in the last column.
www.sqlbi.com/articles/using-visual-ca...
#powerbi #dax
If you are in Houston or you go there on April 26, 2026, don't miss the SQL Saturday that has many sessions about Power BI and Fabric. Of course, with a lot of AI, but we can take it for granted from now on.
We recorded an unplugged session to talk about the third edition of the ๐ ๐ฎ๐๐๐ฒ๐ฟ๐ถ๐ป๐ด ๐๐๐ซ ๐ฉ๐ถ๐ฑ๐ฒ๐ผ ๐๐ผ๐๐ฟ๐๐ฒ: what changed, what is new, and a few behind-the-scenes moments.
www.sqlbi.com/blog/marco/2026/04/01/th...
Should you use DAX user-defined functions (UDFs) or calculation groups?
The question is legit; the answer is that both have a role.
Video and article:ย
www.sqlbi.com/articles/dax-user-define...
#powerbi #dax #udf
The ๐๐ต๐ถ๐ฟ๐ฑ ๐ฒ๐ฑ๐ถ๐๐ถ๐ผ๐ป of the ๐ ๐ฎ๐๐๐ฒ๐ฟ๐ถ๐ป๐ด ๐๐๐ซ ๐๐ถ๐ฑ๐ฒ๐ผ course is ๐ฎ๐๐ฎ๐ถ๐น๐ฎ๐ฏ๐น๐ฒ!
- new features: UDFs, calendars, visual calcs
- smoother learning path
- launch offer available until April 3
Read more details in the official announcement!
www.sqlbi.com/articles/mastering-dax-v...
I'll be speaking about DAX User Defined Functions in Berlin on June 16, 2026, at 18:00 local time.
RSVP: www.meetup.com/berlin-power-bi-user-gro...
If you want more: 3-day DAX in Berlin on June 15-17:
www.sqlbi.com/p/mastering-dax-workshop...
Learn how to transform the like-for-like pattern in a model-independent function so you can easily reuse it.
Article + video on SQLBI.
#dax #udf #powerbi
www.sqlbi.com/articles/creating-functi...
๐จ๐ป๐ฑ๐ฒ๐ฟ๐๐๐ฎ๐ป๐ฑ๐ถ๐ป๐ด ๐ฉ๐ถ๐๐๐ฎ๐น ๐๐ฎ๐น๐ฐ๐๐น๐ฎ๐๐ถ๐ผ๐ป๐ ๐ถ๐ป ๐๐๐ซ is the new course just released to ๐ฆ๐ค๐๐๐+ subscribers:over ๐ฎ.๐ฑ ๐ต๐ผ๐๐ฟ๐ ๐ผ๐ณ ๐๐ถ๐ฑ๐ฒ๐ผ and a ๐ฃ๐๐ ๐๐ต๐ถ๐๐ฒ ๐ฝ๐ฎ๐ฝ๐ฒ๐ฟ.
More details in the ๐ฎ๐ป๐ป๐ผ๐๐ป๐ฐ๐ฒ๐บ๐ฒ๐ป๐ ๐ฏ๐น๐ผ๐ด ๐ฝ๐ผ๐๐: www.sqlbi.com/blog/marco/2026/03/04/sq...
Use the TOJSON and TOCSV functions to inspect the content of intermediate table variables when debugging a DAX measure.
Article + video available!
#powerbi #dax
www.sqlbi.com/articles/debugging-dax-v...
The new calendar-based time intelligence functions offer greater flexibility than the classic ones.
Learn DATEADD parameters for controlling different granularity shifts.
#dax #powerbi
www.sqlbi.com/articles/understanding-d...
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
www.sqlbi.com/articles/show-transactio...
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.
www.sqlbi.com/blog/marco/2026/01/24/fi...
"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/
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 ๐ถ๐บ๐บ๐ฒ๐ฑ๐ถ๐ฎ๐๐ฒ ๐๐ต๐ถ๐ฝ๐ฝ๐ถ๐ป๐ด.
www.sqlbi.com/books/the-definitive-gui...
This article analyzes the performance of regular versus limited relationships in DAX to understand the implications of using limited relationships.
#powerbi #dax #optimization
www.sqlbi.com/articles/analyzing-the-p...
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?
How many other times should I read that a dimensional model exists only because the third-normal-form is slower?
Dude, next time you write a statement like this, pause for a minute.
I don't ask you to study; this would be clearly too much to ask.
Just ask your favorite LLM.
You're welcome.
*2025 DAX recap*
UDFs
Calendar-based time intelligence
21 new DAX functions
*SQLBI*
Definitive Guide to DAX 3rd ed.
SQLBI+ content
DAX Lib
DAX Optimizer Basic
Blog: www.sqlbi.com/blog/marco/2025/12/29/wh...
Video:
๐๐ผ๐ผ๐ธ ๐๐ฝ๐ฑ๐ฎ๐๐ฒ: 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:ย www.sqlbi.com/books/the-definitive-gui...
This article+video describes the data model and DAX measures to analyze campaign effectiveness ๐ฎ๐ป๐ฎ๐น๐๐๐ฒ ๐ฐ๐ฎ๐บ๐ฝ๐ฎ๐ถ๐ด๐ป ๐ฒ๐ณ๐ณ๐ฒ๐ฐ๐๐ถ๐๐ฒ๐ป๐ฒ๐๐ by separating ๐ฎ๐๐๐ฟ๐ถ๐ฏ๐๐๐ฒ๐ฑ ๐๐ฎ๐น๐ฒ๐ from ๐ถ๐ป๐ณ๐น๐๐ฒ๐ป๐ฐ๐ฒ๐ฑ ๐๐ฎ๐น๐ฒ๐.
#dax #powerbi
www.sqlbi.com/articles/measuring-the-i...
๐๐๐ซ ๐๐ถ๐ฏ is quickly becoming the shared home for UDFs in DAX:ย ๐๐ต๐ฒ ๐ฐ๐ผ๐บ๐บ๐๐ป๐ถ๐๐ ๐ต๐ฎ๐ ๐ฎ๐น๐ฟ๐ฒ๐ฎ๐ฑ๐ ๐ฐ๐ผ๐ป๐๐ฟ๐ถ๐ฏ๐๐๐ฒ๐ฑ ๐ฏ๐ฌ+ ๐น๐ถ๐ฏ๐ฟ๐ฎ๐ฟ๐ถ๐ฒ๐ that you can import into your Power BI models using TMDL scripts.
Watch what DAX Lib is, why it matters, and how you can start using it.
The 3rd edition of The Definitive Guide to DAX is available.
We have seen quality issues with the Kindle format. You might want to wait for that.
PDF is the best format for rendering, with no quality issues.
Enjoy DAX!
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
www.sqlbi.com/articles/using-rank-inst...
Cyber Monday is your last stop if you missed Black Friday!
This is your last chance to enjoy 20% off all SQLBI video courses!
https://sqlbi.com/campaign/cyber-monday/
#dax #powerbi #fabric #ssas #training