Category: Scenario Analysis

Creating A Pareto Chart In Power BI – Advanced DAX

Creating A Pareto Chart In Power BI - Advanced DAX

This blog tutorial showcases a really interesting example around Pareto analysis. I’m going to teach you how to create a Pareto chart using advanced DAX formulas. I’ll show you how to use a combination of formulas to be able to generate a visualization like this one. The first thing that I always recommend when working

Continue reading

Using Advanced DAX For Multiple IF Statement In Power BI

In this article, I’m going to give you a tutorial about utilizing multiple IF statements in Power BI. This short tutorial is from a specific thread in the Enterprise DNA Support Forum. In the Enterprise DNA Support Forum, members ask questions and get assistance about everything and anything related to Power BI. It’s great to

Continue reading

Optimize Power BI Formulas Using Advanced DAX

I’ll go over some interesting concepts that involve using several table functions to optimize your Power BI formulas. I’m going to use an example from the Enterprise DNA Support Forum where one of the members asked if it’s possible to add a filter while using the SUMMARIZE function. This is quite common for scenarios when

Continue reading

How To Create A Forward Forecast In Power BI: Advanced Forecasting Techniques

Forecasting analysis in Power BI can be completed in quite an effective manner if you utilize the time intelligence functions in DAX effectively. In this example, I go through the many options you have available to automatically create a forecast in Power BI based on historical information. Your forecasts in a lot of cases will

Continue reading

Effective Ways To Use The GROUPBY Function In Power BI

In this insightful tutorial, I want to feature the GROUPBY function in Power BI. I’ll demonstrate the different ways that you can use this DAX function. Honestly, I haven’t used the GROUPBY function too often, mainly because there are several ways to solve things in Power BI using other table functions. For instance, I’ve used

Continue reading