dax

To set the stage, I need you to travel back in time with me a bit. The year was 2019, and none of us had ever heard of COVID-19…those were simpler

Rolling averages (a.k.a. moving averages or running averages) over time are useful to smoothen chart lines and to make trends more evident. This article sho

Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. However there is a hack to […]

This article describes how to use KEEPFILTERS in DAX iterator functions to preserve arbitrarily shaped filters in context transition. When you apply a filte

This trick will blow your mind! Learn how to create a custom rating visual by writing a few lines of DAX!

DAX (Data Analysis Expressions) is the programming language of Power BI and it was created in PowerPivot for Excel back in 2010, integrated in SSAS Tabular and then, in 2015 in Power BI. There are two main types of users who are learning Power BI (and also DAX if they really want to master Power

.Use calculation groups in Power BI to control when measures get processed using an Apply All button

In this blog post, I will give you a comprehensive overview on the Power BI calculation groups. I’ll share with you some of my tutorials around calculation groups and you’ll see how and when to use them.    Calculation groups are a collection of items, which are basically the same measures that you ...

What you can do and why you should Have you ever been facing the problem of showing small and large numbers together (e.g. 123,456, 789.99 and 34.56) in a nice way, lets say with a 3 digit precison as 34.5 and 123G (or 123E6).   When working with large numbers you can divide them with 1,000 or 1,000...

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

To set the stage, I need you to travel back in time with me a bit.The year was 2019, and none of us had ever heard of COVID-19…those were simpler times.I was working on a data model that had A LOT of …

This article describes how to use KEEPFILTERS in DAX iterator functions to preserve arbitrarily shaped filters in context transition. When you apply a filter in CALCULATE or CALCULATETABLE, by default the filter overwrites any existing filter over the columns specified in the filter. In order to avoi

In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection with a slicer. This can be applied to any number of months. The end result in this scenario is a report where the user has selected a date with

AddColumns is a DAX function that is helpful often when writing calculations in Power BI. In this article and video, I’ll explain how you can use it to add calculated columns on the fly to the virtual tables in measures or directly in a table. AddColumns DAX Tabular Function AddColumns is a tabular function in Read more about How to use AddColumns function in DAX and Power BI[…]

A walk through on how to build a measure in Power BI that lets you group and count the last known state for a given set of items

How to display the distribution of the distance between transactions in a column chart? Let’s see how to implement a complex calculation splitting a c

Being a Power BI enthusiast, I always find DAX a challenge but have found success by keeping to a couple of simple tricks. In this Power BI Tutorial, we review my DAX development workflow through an example case where we will use Power BI Desktop to create a KPI measure

Sum the visible values of a table in Power BI

Previously I explained the AddColumns function as a function that adds one or more columns to the existing table, In this article and video, I’ll explain another similar and useful function with slightly different behavior: SelectColumns, and you will learn how you can use it in Power BI and DAX. SELECTCOLUMNS is a Tabular function Read more about Create a subset of the table in Power BI and add calculations using SELECTCOLUMNS DAX Function[…]

This article describes the differences between eager evaluation and strict evaluation in DAX, empowering you to choose the best evaluation type for your data models. A conditional expression in DAX – like an IF function – can be evaluated in two ways: eager and strict. Understanding the difference be

In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection

If you want to show the ranking in a Power BI visual, one way is to use a visual that supports that, such as a Ribbon chart. Another way, which is a more common way, is to write a calculation for rank, and RANKX is a DAX function that can help you with that. In Read more about Showing Ranking in a Visual in Power BI using RANKX DAX function[…]

This article describes a very common optimization pattern that relies on variables to optimize conditional expressions in DAX. In a previous article we show

Learn how to write calculations in Power BI for comparing values of a month with the month before and get variance and percentage.

learn how to use TopN function in DAX either to create a calculated table, or to use it in a measure to achieve analysis such as; comparison with the average amount of the top group.

Learn how to filter the data for a calculation in a DAX expression in Power BI. You can apply multiple conditions using AND or OR operators.