Tag: Iterating Functions

Getting Started With The “What If” Parameter In Power BI

The possibilities of using the What If parameter in Power BI is deemed endless. It gives users and businesses the flexibility to design a solution for the critical answers and insights that they need. In the recent Enterprise DNA learning summit, we had a successful session regarding the usage and implementation of What If Parameter

Continue reading

Procurement Decisions Model And Analysis In Power BI

In this tutorial, we’re going to dive into some procurement analysis or purchasing decision-making within organizations. This tutorial demonstrates the versatility of Power BI when it comes to helping make insightful decisions for a procurement division. I’m going to run through an intro example where we’ll start from raw data, create a quick data model,

Continue reading

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