-
This article describes how to write DAX measures that compute aggregations or comparisons with past dates without showing or comparing future dates. Read more
-
This article explains how the CONTAINS function works and what can be used as better alternatives in DAX in common use cases. Read more
-
This article describes how to use calculation groups to dynamically replace only a partial expression in a complex DAX calculation. Read more
-
This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT or FILTER. Read more
-
This article analyzes a classic modeling question: is it better to build a model as a regular star schema or as a single table in Power BI? The answer is clear: a star schema is always the best choice. Read more
-
Context transition is one of the most obscure topics for DAX newbies. In this article we introduce context transition, its effects, and how to leverage it rather than be scared of it. Read more
-
In DAX string comparison requires you more attention than in SQL, for several reasons: DAX doesn’t offer the same set of features you have in SQL, a few text comparison functions in DAX are only case-sensitive and others only case-insensitive,… Read more
-
This article describes how to implement a syntax equivalent to the T-SQL function NULLIF and the ANSI SQL function COALESCE, in DAX. Read more
-
This article describes the small differences between INT and CONVERT in DAX that may end up returning different results in arithmetic expressions. Read more
-
This article describes how to use DAX Studio to capture DAX queries generated by Power BI. Analyzing DAX queries can be helpful to better understand performance issues, and to improve the writing of DAX queries. Read more