DAX

I was just working on a client project where we have several complex measures that reference other measures. Sometimes it can be hard to keep all these dependencies in mind. As a feature, it would be …

Introduction: Around 2014, an enhancement was made to the DAX engine designed to help improve query speed. The enhancement, called DAX Fusion, looks to reduce the number of storage engine scans nee…

What if you can find all details about DAX measures, and find all of the expressions that have an error in their syntax? Power BI Helper July 2019 version can do that for you. But not just that, it ca…

Debugging DAX codes can be sometimes a bit of challenge, especially because measures are dynamic in their nature, and you won't see their values in the data tab of Power BI, you will see their value w…

By In this article, I want to show you how I achieved a business solution using DAX. Let me explain the requirement. I have a below table and customer wants the data in the below format. Country Color…

This article describes different techniques to display the first three products for each category in Power BI. It includes considerations on how to adapt th

I was having a discussion earlier this week about the use of variables I used in my currency conversion blog post . The question was why I am using 2...

The Tip: Convert calculated columns in your model to physical columns (where practical). The Detail If you encounter memory issues when processing partitions in an Analysis Services (AS) database, …

This article explains the precedence of calculation groups in DAX, needed whenever multiple calculation groups are present within the same model. Before sta

This is not so much a DAX tip, rather something you might consider if you want to speed up the performance of any Direct Query (DQ) model you manage in Power BI or Analysis Services. The simple tip…

Although very simple, still I see many Power BI reports with no organized way of separating measures. When you use Power BI for a while, you will gradually have more DAX measures and calculations, and…

When creating a budgeting prediction, most of the time we are creating it on the higher granularities. Rarely we do it on a daily basis.But sometimes we are required to match budgets to actual sales o…

Level: Intermediate Pareto Analysis is a statistical technique that applies the Pareto Principle to data. This is more commonly known as the 80:20 Rule. The Pareto Principle is based on the presump…

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 sta

The problem of blank values being shown in a Power BI slicer is fairly well known, but did you know that in some circumstances slicers can show other values that you would not expect to see? While the…

This blog post shows how to use a DAX measure with adding in line breaks with Power BI which makes for easier reading of filters

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 t

SUMPRODUCT is a very powerful formula for filtering criteria in both columns and rows. This post will show you how to use OR and AND criteria together.

Introduction For this blog, I look at a method to take some text in the form of a horizontal sentence and use DAX to pivot the text into a vertical list of words. The PBIX file for this exercise ca…

Have you ever wished to see what all the variables in your DAX code contain? Debug DAX variables with the function presented in this article.

An interesting – if obscure – fact I learned recently is that a small number of DAX functions such as Median() do not work on tables with more than 2 billion rows in Analysis Services Tabular, Azure AS…

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,

Video by: Reid Havens Learn how to implement some advanced DAX measure organization and sorting within Power BI. Including creating nested folders and putting one measure in two different folders .

This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure. In this example, using CONCATENATEX helps iden

In the previous article, I explained how you can build a data model for budget vs. actual, where the grain of the two fact tables is different. The model works perfectly as a star schema. As long as y…

Level: Intermediate I was delivering some training last week for a customer in Sydney and they participants had an interesting problem where they needed to be able to report on a rolling time windo…

The June 2019 update of Power BI includes the ability to filter slicer items based on a measure. This article explains why this is an important feature that

When I explain the Star Schema and best practices of data modeling in Power BI, Often I get questions such as what if we want to have budget and actuals in the same data model? what if there are two tables with different granularity? We cannot solve it with simple data modeling and relationships, this…