DAX

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

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

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

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[…]

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

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

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 a naming convention for temporary columns in DAX expressions to avoid ambiguity with the measure reference notation. Table functions

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...

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 ...

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

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

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

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

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 […]

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

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

When I first started learning about Calculation Groups, I could certainly see how much potential this new DAX feature would eventually have. Out of the gate however, there were a limited number of …

I previously wrote a blog post explaining how to rename all columns in a table in one go with Power Query. One of my visitors raised a question in the comments about the possibility to rename all columns from all tables in one go. Interestingly enough, one of my customers had a similar requirement. So … Continue reading Quick Tips: Renaming All Tables’ Columns in One Go in Power Query

We are proud to announce great news for DAX Guide! Starting today, every DAX function has its own dedicated video. Moreover, we added new examples that you

This article explains the most common causes of the error, “A circular dependency was detected” in Power BI and Analysis Services. A circular dependency

There is just one thing that is more satisfying than writing complex DAX measures, and that is avoiding complex DAX due to smart data modeling.

In this blog post, we are going to dive into the world of averages and how to solve problems when calculating averages by using CALCULATE, SUMMARIZE and AVERAGEX. Specifically, we look at creating …