Tag: SUMX

Scenario Analysis Techniques Using Multiple ‘What If’ Parameters

Power BI is an incredible tool to run scenario analysis and what-if analysis examples. I’ve actually never seen or come across an analytical tool that is as effective and intuitive to implement this type of complex analytics. You may watch the full video of this tutorial at the bottom of this blog. The key is

Continue reading

Using Iterating Functions SUMX And AVERAGEX In Power BI

One of the most crucial topics for any Power BI beginner to know about is iterating functions. You may watch the full video of this tutorial at the bottom of this blog. So before you dip your head in working with complex calculations, I will share with you some simple iterating functions in this article.

Continue reading

Discover Where Your Profit Growth Comes From: A Power BI Tutorial

In this Power BI tutorial, I dive into what’s perhaps a very niche insight. But don’t let that close you off to using this technique — there are plenty of ways to implement this across a range of scenarios. The key is to understand each different part and transfer them across similar elements in your

Continue reading

Comparing Calculated Columns And Measures In Power BI

Measures vs Calculated Columns In Power BI

In this tutorial, I will cover the two places where you can write your DAX formulas. These two places are the calculated columns and measures. You may watch the full video of this tutorial at the bottom of this blog. I will go over each one at a time and I’ll start with calculated columns.

Continue reading

DAX Calculations: Total Of Average Results

This is a very good demonstration of DAX calculations in Power BI. I will show you how you can calculate the total of a range of average results, utilizing the correct DAX formula combination. You may watch the full video of this tutorial at the bottom of this blog. This requires a reasonable understanding of

Continue reading