Tag: SUMX

Power BI Calculated Column vs Measure: A Comparison

In this blog, I’m going to compare Power BI calculated column and measures, and then cover some of their differences. You may watch the full video of this tutorial at the bottom of this blog. I’m also going to show you optimal situations where you can use either of them. Creating Calculated Columns I’m going

Continue reading

The Difference Between SUM vs SUMX In Power BI

SUM vs SUMX What's The Real Difference Between These DAX Measures

There is still a lot of confusion about the difference between SUM vs SUMX in Power BI. This is key knowledge that users have to master because both functions can be used across different scenarios, but there are cases where one is more efficient than the other. You may watch the full video of this

Continue reading

Showing The Last Three Customer Sales Using The TOPN Function

I’m going to cover some great functions here in Power BI that are very useful across a variety of analytic scenarios. Some of these functions can help us work out the last three customer sales. You may watch the full video of this tutorial at the bottom of this blog. What I want to show

Continue reading

How To Use Iterating Functions To Fix Total Issues In Power BI – DAX Concepts

How To Use Iterating Functions To Solve Total Issues In Power BI - DAX Concepts

I’m going to show you today how to use iterating functions when you’re trying to fix Total issues in Power BI. You may watch the full video of this tutorial at the bottom of this blog. When I go through the questions posted on the Enterprise DNA support forum for members, I see a lot

Continue reading

Virtual Tables Inside Iterating Functions In Power BI – DAX Concepts

Virtual Tables Inside Iterating Functions In Power BI – DAX Concepts

In this tutorial, I’m going to cover a very interesting topic around virtual tables, and how you can utilize them in Power BI within iterating functions. You may watch the full video of this tutorial at the bottom of this blog. Virtual tables are the essential ingredient to creating advanced logic in Power BI. There’s

Continue reading