DAX

Power BI has a robust set of functions to write date-based calculations. One of the areas that has proven to be a challenge is related to doing math on working days instead of normal dates. \ Here …

This article describes how DAX automatically converts data types in arithmetic operations. These small details can cause and explain differences in results

While Power BI has a lot of great functionality for filtering the data that appears in a visual using visual-level filters there are going to be situations where you need more control over how filteri…

Hit this link to download the new aMAZEing DAX Game. Phil Seamark has made another great game that you should definately check out. Hit the link to Download

Sum and Sumx are functions that often founded to be misleading for many Power BI users. As both functions are doing the aggregation, it seems a bit confusing what is the actual difference between thes…

This article shows how to improve line charts with a date-based axis in Power BI using DAX and correct choices in data modeling and visualization properties

In the November release of Power BI desktop we introduced a new DAX expression that is really great. Working with hierarchies in DAX have always been a bit of a...

Navigating the sea of data One of the many things which amaze me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens. For e…

I had a requirement where the customer wanted the difference between 2 values in a table. The challenge here was that because the values are already part of the table, I had to find a way to get th…

I watched a video from Guy in a Cube’s Patrick featuring Marco Russo where they walked through an example using a technique to debug DAX measures using VAR/RETURN – I loved this! https://www.youtube.com/watch?v=9SV2VnYbgg4 The video made me recall another Blog Post by Matt Allington, where he stepped through an

This blog post explains how the ISINSCOPE DAX function works, how it is different from ISFILTERED and ISCROSSFILTERED, and when it can be useful.

This article describes how variables should be used in DAX expressions involving IF and SWITCH statements in order to improve performance. In DAX, variables

With apologies to Theodor Geisel... Measure totals have you perturbed? Fear not! It's Measure Totals, The Final Word, These measures work with matrices, They work with tables, They work with rows and columns and labels. They work in the daytime, They work at night, They work to make sure the t...

Here is a technique you might consider if you need to split text down to individual words. This could be used to help count, rank or otherwise aggregate the words in some longer text. The approach det…

This article describes how to create a measure displaying the name or value of an element that has a specific ranking, with different option for managing ti

Today I want to share a scenario where a running total calculation in the query editor saved a model that run out of memory when done with DAX:

This article describes the behavior of auto-exist in DAX, explaining the side effects of combining slicers on columns of the same table in Power BI. Auto-ex

Power BI has the ability to apply conditional formatting to values in table columns. The functionality for managing colors and parameters used in Power BI didn’t provide granular control. In a recent update to Power BI, the ability to use DAX measures to control conditional formatting was introduced.

Functions Browse DAX functions alphabetically from the sidebar or choose a category: • Aggregation functions Aggregation functions return a scalar value applying an aggregation function to a column or…

If you have read the book Alberto and I wrote, “The Definitive Guide to DAX” then by looking at the title you might think that this post is about the bo

I was recently doing some work for a customer where they wanted to compare their date to the start date of the following week. They also had a requirement to persist the data to the dataset. I thou…

A common accounting task is to consolidate the financial results of subsidiary companies into combined results of a parent company. A parent company can have one or multiple subsidiaries. Each subsidiary can also have one or multiple subsidiaries beneath it. The relationships between parent companies and subsidiaries

Earlier this week I posted a challenge for creating a dynamic date filter using DAX. If you want to see the challenge first and see if you can solve it, check out that post first. If you just want …

In this week’s episode of Insight Quest, Anna, the team BI manager, has assigned two work items to Brett, the BI developer, as part of the current sprint. The first task is to develop and tes…