dax

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…

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.

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…

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.

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

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

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

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…

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…

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…

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…

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

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, …

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

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

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…

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…

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…

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…

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 …

Here are 15 awesome DAX Keyboard Shortcuts in Power BI to help you write and debug your DAX code faster and smarter.

Learn how to calculate 50 and 100-day moving average with DAX for your Excel cryptocurrency dashboard. With video and Learn and Earn activity

This week, I got an interesting question about Power BI: “Can I format a specific cell or row in a table or matrix?” My answer was yes and I thought it could be a great blog. Let’s say, you need to format the Sales Amount for all countries as a whole number, except for Australia. ... Read morePower BI: How to format a specific cell or row in a table or matrix?

Now that you can create icons in Power BI, a common question is "where can I get a list of icon names?". This article provides a list of all standard icons.

There are two functions in DAX that return the list of values of a column: VALUES and DISTINCT. This article describes the difference between the two, expla

The DAX functions CONVERT and REMOVEFILTERS were introduced in August 2019. This blog post shows what they do.