Topic: DAX

        370 posts
DAX 101 –

Previous year up to a certain date

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

article –

Blank row in DAX

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

Calculation Groups –

Understanding Calculation Group Precedence

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

Calculation Groups –

Understanding the Application of Calculation Items

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

video –

Deep dive into DAX evaluation context

Ever struggled with a formula in DAX that does not compute what you want? It has happened to us many times, and we know that the problem is ALWAYS related to the evaluation context. Filter context, row context, and context…  Watch now

Calculation Groups –

Understanding Calculation Groups

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