Tag: SUMX

UNION DAX Function Vs Power Query

UNION DAX Function Vs Power Query - Enterprise DNA

In this tutorial, you’ll learn a DAX optimization technique using the UNION function. This tutorial will compare the performance of the UNION function versus Power Query and other techniques for combining tables. The UNION function combines two tables into a single table by combining their rows and removing any duplicate rows. The example in this

Continue reading

A Power BI DAX Tutorial On Cumulative Comparisons

A Power BI DAX Tutorial On Cumulative Comparisons

In today’s Power BI DAX tutorial, I want to go over quite an interesting technique that uses DAX really effectively. I had to work on a scenario where we were running some analysis on our email campaigns. I wanted to know how many emails we receive in a day, compare it on a monthly basis,

Continue reading

Calculate Percentage Margin In Power BI Using DAX

Calculate Percentage Margin In Power BI Using DAX

Today, I’m going to do a quick and easy tutorial on how to calculate one of the most commonly used metrics, especially if you’re dealing with sales, revenues, or transactions. We’ll calculate the percentage margin. I’m going to use profit margin as an example here, but this technique doesn’t have to be always related to

Continue reading

DAX Power BI: What Is Row Context

In this blog, we are going to dive into row context in DAX Power BI. Another way to call it is the iterating calculation engine, but it is called row context from a more technical perspective. You may watch the full video of this tutorial at the bottom of this blog. DAX Power BI: Row

Continue reading

How To Use An Iterating Function In Power BI

This tutorial will teach you about different iterating functions and how to efficiently use them in your calculations. I often discuss how calculated columns are not required when making some calculations. This is because of iterators. Iterators or iterating functions can help you do a calculation without physically putting the results in the table. This

Continue reading