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
Tag: DAX formula
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
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
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.
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