ViewTube

Defining the right contract is a key activity for a DAX developer using AI. Here we introduce the concept of a contract through ...

A simple daily average can hide complexities and return different values. We explore several edge-case scenarios to build the ...

Should you use DAX user-defined functions (UDF) or calculation groups? Learn when to use either, and how they complement ...

Learn the differences between similar but different DAX functions that remove filters from the filter context. Article and download: ...

How to define optional parameters in DAX user-defined functions and set default values for parameters not specified by the caller.

The time has come: in 2026, using AI to write DAX has started to be effective. Latest news and the new courses are at ...

How to find evergreen products in DAX. Top 10 products are a classic. Reporting which products are in the top ...

A DAX calculation can produce convincing values at the detail level and fail at the total. The problem is often that the business rule ...

How to apply a different formatting rule at each level of a hierarchy using ISINSCOPE in a measure or ISATLEVEL in a visual ...

How to highlight a row based solely on the maximum value in the last column using visual calculations, a tool that can be used ...

How to use AI to identify relevant test cases in a semantic model and create repeatable DAX tests for a measure. Article and ...

Learn how to specify the parameter types in DAX user-defined functions using MEASUREREF, COLUMNREF, TABLEREF, and ...

How to leverage AI to refactor existing DAX code, remove duplicated parts, and centralize the common code in user-defined ...

Create a DAX model-independent user-defined function (UDF) to easily apply the like-for-like pattern to your data. Article and ...

Differences between model-dependent and model-independent DAX user-defined functions: how dependencies impact portability ...

When to use VALUES in the table grouped by SUMMARIZE, and why SUMMARIZECOLUMNS does not have that option.

The new DATEADD parameters in DAX add greater flexibility to the calendar-based time intelligence in Power BI. Learn how they ...

A slicer cannot filter a measure: let's analyze this common request by explaining how to use a slicer to filter a measure, after ...

How to use the TOJSON and TOCSV functions to inspect the content of intermediate table variables when debugging a DAX ...

DAX Lib is an open-source repository of User-Defined Functions (UDFs) for Power BI, Fabric, and Analysis Services. Learn how ...