This article describes a naming convention for temporary columns in DAX expressions to avoid ambiguity with the measure reference notation.  Read more

This article describes what weak relationships are and the differences between strong and weak relationship in Power BI and DAX.  Read more

This article describes how to compute previous year values up to a certain date. This is useful in case the data is presenting incomplete months or years.  Read more

This article describes how to create a slicer showing the values of multiple columns, applying the filter on any of the underlying columns.  Read more

There are two functions in DAX that return the list of values of a column: VALUES and DISTINCT. This article describes the difference between the two, explaining the details of the blank row added to tables for invalid relationships.  Read more

This article describes different techniques to display the first three products for each category in Power BI. It includes considerations on how to adapt the technique to different models and requirements.  Read more

This article explains the precedence of calculation groups in DAX, needed whenever multiple calculation groups are present within the same model. Before starting, we suggest you read the previous articles in this series.  Read more

This article explains how calculation items are applied to measure references, and it is part of a series dedicated to calculation groups in DAX. Before starting, we suggest you read the previous articles in this series.  Read more

This article explores the properties of calculation groups in detail and then it describes how a calculation item is applied to a measure. Before starting, we suggest you read the previous article that introduces calculation groups.  Read more

This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure.  Read more