Tag: Iterating Functions

Iterating Functions In DAX Language – A Detailed Example

For this blog post, I want to dive into iterating functions within the DAX language in Power BI. The reason why I want to spend some time showing what you can do inside of iterating functions is because it’s such an important concept that you need to learn very well. You might have only just

Continue reading

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. The key is that you’ve got to think more analytically about the underlying elements in your datasets than

Continue reading

Power BI Analytics: Run Scenario Analysis On Average Order Size

In this tutorial, we dive into the power of Power BI analytics. I’m going to go through something quite practical for a retailer who sells goods at a high frequency. When you are a business that sells a lot of goods – say an online retailer – if you can analyse how much you would

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. So before you dip your head in working with complex calculations, I will share with you some simple iterating functions in this article. Why Use Iterating Functions? I get this question all the time as I do live

Continue reading

Working With Iterating Functions In DAX

Iterating Formulas Deep Dive Power BI

I’ve seen some confusion with iterating functions in DAX whenever I work with Enterprise DNA members in the forum. So we will do a review of what can be achieved using these functions and why you should use them. As you get more into DAX formulas, you will use these iterating functions a lot more

Continue reading