This article+video shows how to leverage AI to refactor existing DAX code, remove duplicated parts, and centralize the common code in user-defined functions. #dax #powerbi #udf https://www.sqlbi.com/articles/creating-dax-functions-with-ai-to-remove-duplicated-code/

The new default visual style in Power BI does not have alternate colors, but you can get it back! #powerbi  https://www.sqlbi.com/blog/marco/2026/08/10/restoring-alternating-rows-in-power-bi-matrices-with-fluent-2/

Any plans for the weekend?

Visual calculations can either improve or degrade the performance of a report. In this article + video, we show how to ensure visual calculations have a positive impact on performance. #dax #visualcalc #powerbi https://www.sqlbi.com/articles/analyzing-the-performance-impact-of-visual-calculations/

Everyone is talking about movie formats right now, and IMAX gets the votes because it shows the bigger picture. Should your reports get an IMAX format too?

This article and video describe how to apply different formatting rules at each level of a hierarchy in Power BI using ISINSCOPE in a measure or ISATLEVEL in a visual calculation. #dax #powerbi https://www.sqlbi.com/articles/dynamic-formatting-by-hierarchy-level-with-isinscope-and-isatlevel/

𝗦𝘆𝗻𝗼𝗽𝘁𝗶𝗰 𝗗𝗲𝘀𝗶𝗴𝗻𝗲𝗿 𝟮.𝟬 𝗶𝘀 𝗻𝗼𝘄 𝗹𝗶𝘃𝗲! We completely redesigned it to make it easier and faster to create custom maps for Synoptic Panel in Power BI. Watch the video to see it in action, then create your next custom map at https://synoptic.design #PowerBI #DataVisualization #SynopticPanel

It's Saturday. Name a DAX function that doesn't exist but absolutely should.  Wrong answers only. 😎 I'll start: MAKENOMISTAKES().

In this article+video, we implement a DAX user-defined function that removes filter-keep column filters from a calendar, using REMOVEFILTERS as the return value of the function. #dax #calendar #daxudf #powerbi https://www.sqlbi.com/articles/using-removefilters-in-dax-user-defined-functions/

This article/video describes how to define optional parameters in DAX user-defined functions and set default values for parameters not specified by the caller. #dax #powerbi #udf https://www.sqlbi.com/articles/optional-parameters-in-dax-user-defined-functions/

We introduced comics to the SQLBI Newsletter almost one year ago. Lately, they are starting to realize they are not real.  How do you know you are not in a simulation? Wrong answers only! 😎

ALL, ALLSELECTED, ALLEXCEPT, and REMOVEFILTERS: There are several DAX functions to remove filters from the filter context. This article + video clarifies what to use depending on the requirements. #dax #powerbi https://www.sqlbi.com/articles/all-vs-allselected-vs-allexcept-vs-removefilters/

This article+video describes the Expression Context property, explaining how 𝘂𝘀𝗲𝗿-𝗮𝘄𝗮𝗿𝗲 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲𝗱 𝗰𝗼𝗹𝘂𝗺𝗻𝘀 work, how to use them as 𝘃𝗶𝗿𝘁𝘂𝗮𝗹 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲𝗱 𝗰𝗼𝗹𝘂𝗺𝗻𝘀 for localization and custom security. #powerbi #dax https://www.sqlbi.com/articles/introducing-user-aware-calculated-columns-in-power-bi/

A slicer cannot filter a measure. This article+video analyzes this common request by explaining how to use a slicer to filter a measure, after discussing the real meaning of using a measure with a slicer. #powerbi #dax https://www.sqlbi.com/articles/filtering-measures-through-slicers/

Almost there! #dax #udf https://roadmap.fabric.microsoft.com/?product=powerbi

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 https://www.sqlbi.com/articles/understanding-parameter-types-in-dax-user-defined-functions-udf/

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. https://www.sqlbi.com/articles/using-visual-calculations-to-highlight-an-entire-row/ #powerbi #dax

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. https://www.sqlbi.com/blog/marco/2026/04/01/the-third-edition-of-the-mastering-dax-video-course-unplugged/

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:  https://www.sqlbi.com/articles/dax-user-defined-functions-udf-vs-calculation-groups/ #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! https://www.sqlbi.com/articles/mastering-dax-video-course-3rd-edition/

I'll be speaking about DAX User Defined Functions in Berlin on June 16, 2026, at 18:00 local time. RSVP: https://www.meetup.com/berlin-power-bi-user-group/events/313692296/ If you want more: 3-day DAX in Berlin on June 15-17: https://www.sqlbi.com/p/mastering-dax-workshop-berlin-jun-15-17-2026/

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 https://www.sqlbi.com/articles/creating-functions-for-the-like-for-like-dax-pattern/

𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱𝗶𝗻𝗴 𝗩𝗶𝘀𝘂𝗮𝗹 𝗖𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗶𝗼𝗻𝘀 𝗶𝗻 𝗗𝗔𝗫 is the new course just released to 𝗦𝗤𝗟𝗕𝗜+ subscribers:over 𝟮.𝟱 𝗵𝗼𝘂𝗿𝘀 𝗼𝗳 𝘃𝗶𝗱𝗲𝗼 and a 𝗣𝗗𝗙 𝘄𝗵𝗶𝘁𝗲 𝗽𝗮𝗽𝗲𝗿. More details in the 𝗮𝗻𝗻𝗼𝘂𝗻𝗰𝗲𝗺𝗲𝗻𝘁 𝗯𝗹𝗼𝗴 𝗽𝗼𝘀𝘁: https://www.sqlbi.com/blog/marco/2026/03/04/sqlbi-updates-in-march-2026/

Use the TOJSON and TOCSV functions to inspect the content of intermediate table variables when debugging a DAX measure. Article + video available! #powerbi #dax https://www.sqlbi.com/articles/debugging-dax-variables-using-tojson-and-tocsv/

The new calendar-based time intelligence functions offer greater flexibility than the classic ones. Learn DATEADD parameters for controlling different granularity shifts. #dax #powerbi https://www.sqlbi.com/articles/understanding-dateadd-parameters-with-calendar-based-time-intelligence/

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/

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/

"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 𝗶𝗺𝗺𝗲𝗱𝗶𝗮𝘁𝗲 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴. 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/