dax

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…

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.

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

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 how to create a measure displaying the name or value of an element that has a specific ranking, with different option for managing ti

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…

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

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

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

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

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…

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…

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

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

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…

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

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…

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

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 …

Power BI is the (best) data visualization tool of Microsoft. But how to apply your color formatting to your visuals without changing it by hand for every visual separately, which is an option of co…

Activating bidirectional cross-filter in a Tabular data model might create ambiguous paths in the chain of relationships, resulting in very dangerous models

Today I woke up with an interesting question, about how to show a selection of months in a nice way, detecting contiguous selection. You can easily underst

We are approaching the end of 2018, so it is a good time to review what happened in the DAX world this year, what we’ve been up to at SQLBI and what is go

Data lineage is a DAX feature so well-implemented that most developers use it without knowing about its existence. This article describes the data lineage a