DAX user-defined functions (UDFs) are now available on Azure Analysis Services. Do you think there are missing articles about using DAX UDFs? Should I create one about Analysis Services (Azure and on-prem)? https://www.sqlbi.com/dax-user-defined-functions-udf/ *SOTA = state of the art

DAX user-defined functions (UDF) - SQLBI

This page groups articles, videos, tools, and additional material for using DAX user-defined functions (UDFs). Articles List of articles about DAX user-defi

sqlbi.com

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/

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! 😎

DAX User-Defined Functions (UDF) are generally available! The cherry on the cake is optional parameters, included in this release. https://community.fabric.microsoft.com/t5/Power-BI-Updates-Blog/DAX-User-Defined-Functions-Generally-Available/ba-p/5185738 #dax #powerbi #udf

DAX User-Defined Functions (Generally Available)

Author: Kay Unkroth, Principal Program Manager   DAX user-defined functions are now production-ready based on community feedback and internal validation. Their adoption during preview shows that DAX UDFs are quickly becoming a mainstay of Power BI semantic models.   Reusable, discoverable DAX buildi...

community.fabric.microsoft.com

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/

Sunday morning confession: I actually love donuts. #dataviz 

Sugar in the Air [Official]

Some shapes pretend to be simple.Some colors pretend to be honest....

youtube.com

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

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.

Houston Ai-Lytics Day 2026 (#1137)

sqlsaturday.com

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/