Tag: DAX formula

Forecasting Technique: Exploring Forecasting Logic In Power BI Models

If you want to have a real-world example scenario of forecasting using Power BI, you’re in the right page. You’ll find in this tutorial a forecasting technique that you can surely implement in your own work environment. In the example, I compare my actual results to my forecasts and look at them cumulatively. The cumulative

Continue reading

Fixing Incorrect Totals Using DAX Measures In Power BI

Getting totals correct inside Power BI reports can sometimes be the most frustrating thing when utilizing DAX measures. You might probably get into certain situations where your Totals for DAX measures aren’t adding up the way you want them to.  DAX measures can be based on standard aggregation functions, such as COUNT or SUM. These

Continue reading

Discover Multiple Product Purchases Using DAX in Power BI

We’re going to review a unique customer insight in this example. Specifically, we’re going to understand how to work out the number of customers with multiple product purchases. While this might seem like a relatively logical calculation, there’s actually more to it when using DAX. This is a perfect example of how you can utilize

Continue reading

Running Sensitivity Analysis For Power BI Using DAX

Have you ever thought it would be nice to work out what the most optimal outcome is from your scenario analysis work that you’re doing inside of Power BI? In this tutorial, I show you exactly how you can discover this and also include sensitivity analysis techniques to your what-if parameter and scenario analysis work.

Continue reading

How To Evaluate Clusters in Your Data Using DAX Technique in Power BI

In this tutorial, I’m going to show you how showcasing clusters in your data enables you to extract far superior insights than if you just had a scatter chart with a whole lot of information planted in there. I’m going to go through some advanced DAX techniques that you need to utilize in combination with

Continue reading