This article describes the parameter types available in DAX user-defined functions, focusing on the specialized reference types MEASUREREF, COLUMNREF, TABLEREF, and CALENDARREF.  Read more

Visual calculations can be used efficiently to format visuals. This article presents an interesting technique to highlight a row based solely on the maximum value in the last column.  Read more

This article describes the different roles of user-defined functions and calculation groups, explaining when to use either, and how they complement each other in the design of a semantic model.  Read more

The third edition of the Mastering DAX video course is available!  Read more

This article offers a comprehensive guide to changing the like-for-like pattern into model-independent functions to enhance flexibility and simplify DAX code.  Read more

This article describes how to use the TOJSON and TOCSV functions to inspect the content of intermediate table variables when debugging a DAX measure.  Read more

The new calendar-based time intelligence functions offer greater flexibility than the classic time intelligence functions. This article describes the DATEADD parameters for controlling different granularity shifts.  Read more

This article shows how to create a DAX measure that displays information from multiple columns in a business entity or transaction, into a single column of a matrix.  Read more

This article analyzes the performance of regular versus limited relationships in DAX to understand the implications of using limited relationships.  Read more