DAX

in this video I talk about the fatal flaw of the Power BI’s Filter pane and how we can fix it with breadcrumbs. What fatal flaw am I talking about? What the heck is a breadcrumb? Well, watch …

I received feedback on my recent blog post on single-column fusion asking about a curious syntax used in the solution. I promised I would do a deeper dive on why it works in my next blog, so here i…

DAX Fusion Optimising Power BI

In my last tutorial here, you learned how to apply a What-If technique to calculate the estimated active cases of COVID-19. In this part, you will learn how to run running averages to smooth the trend lines of any measure you use. Our analytics objective is simple. The daily new COVID-19 confirmed cases can fluctuate…

In my last tutorial here, you learned how to apply a dynamic running average in DAX. In this part, you will learn how to offset the daily new confirmed cases vertically and horizontally. Horizontal offset - Normalize cases by population Different countries were affected differently by COVID-19. The most common analytic challenge in comparing between…

A common search strategy has to combine multiple items with an AND instead of the default OR. This Power BI file contains two DAX measures solving a search operation with the fancy name: relational division

This blog post lists the new financial DAX functions introduced in June 2020.

I received feedback on my recent blog post on single-column fusion asking about a curious syntax used in the solution. I promised I would do a deeper dive on why it works in my next blog, so here it …

I recently came across an interesting problem regarding how you can show the sum of values of certain selected categories as separate bars in a bar chart – but with the sum of all the non-sel…

In this article, we share an idea to reduce the friction in using Power BI, by extending the DAX language with new visual calculations. At SQLBI, we teach D

This article shows how to use DAX and conditional formatting together to highlight the minimum and maximum values in a matrix in Power BI. Conditional forma

This article explains how to show different customers with the same name in a Power BI report by using zero-width spaces, thus simplifying the presentation

There was a very subtle but important change made in the April 2020 release of Power BI Desktop that you may have missed. Take a look in the format pane on the right in the image below – do you see it? Note the “new” function buttons? When I say [...]Read More »

The more complex a Power BI Custom Data Connector gets, the more cumbersome the main Power Query file becomes. Without the ability to make a true “project” structure and include or dire…

This article describes how to optimize a slow Power BI report that has a large number of card visuals, by obtaining the same graphical layout with a smaller

This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of

We are working hard at Enterprise DNA to build a number of tools that can assist Power BI users in their development work. Today we are excited to announce the release of our DAX Clean Up Tool Why a new tool to format DAX formulas? One of the biggest hurdles that any Power BI user faces when they start developing reports and dashboards is attempting to understand how DAX formulas and DAX code work. WeContinue reading

A quick post today. Sometimes you will be mystified why your aggregations are not getting hit. There is no clear-cut answer to why. The best way to find the underlying...

For someone utterly new to Power BI, and especially for those who have been using Excel, understanding DAX can be an overwhelming experience. At least, it was for me. It took me some time to grasp the concepts, filter and row contexts, and the CALCULATE function. One of the standard requirement...

Objective: We would like to have WTD(Week Till Date) Last WTD and This Week vs Last Week. Dataset: We have taken Sales data. The data is from April 2018 till April 2020. We have created a date Calendar. Steps: We create a Date Calendar With Monday to Sunday Week, with the following week-related...

Slabs or tired calculations are common in income taxes or commission rates. Learn to do slab or tried calculations using DAX in Power BI

I was playing around with calculation groups for a question. I found that adding a calculation group is not that straightforward as it should be, so I decided to blog...

One of the cool things of calculation groups is they cannot just be used to apply a calculation over your “base measure” but also apply a dynamic formatstring. You could...

Substring is one of the most common functions in many languages, However, there is no function named Substring DAX. There is a very simple way of doing it, which I am going to explain in this post. Substring means getting part of a string, for example from "Reza Rad", if I want to get the…

This post walks through a simple use of the coalesce function to prevent a measure returning Blank. This function was introduced to Power BI in March 2020.

Yesterday, I published a post about having a slicer that filters the rows in a table visual in Power BI that contains the characters from that slicer. A friend asked me what if we want to search for the first few characters? that means selecting the first character, then seeing all the possible second characters,…

Doubling times are an indicator to measure the growth rate in exponentially growing scenarios. Learn how to calculate them in DAX for display in Power BI.