Category: Scenario Analysis

3 Ways To Combine Values Using DAX Inside Power BI

For this tutorial, I’ll be showing you different ways of how to combine values using advanced DAX functions. This is an amazing DAX formula and I’ll be teaching you three different ways of how to use it. The COMBINEVALUES function is not a difficult DAX function to understand. It’s very simple and is similar to

Continue reading

Showing The Last Three Customer Sales Using The TOPN Function

I’m going to cover some great functions here in Power BI that are very useful across a variety of analytic scenarios. Some of these functions can help us work out the last three customer sales. What I want to show you is how to work out the sales from a specific customer, but by only

Continue reading

Sensitivity Analysis Examples in Power BI

Sensitivity Analysis Logic Using DAX in Power BI

I want to dive deeper and show you the ways of implementing some sensitivity analysis examples in your Power BI model. Sensitivity analysis is a very important financial model. It helps businesses in predicting the outcome of a certain scenario, like customer and cost changes, to the overall gains of company. In a previous tutorial

Continue reading

Effective Techniques for Profit Prediction Using Power BI

What I want to cover with this tutorial are some great examples of profit prediction in the future using Power BI. To achieve this in Power BI you need a number of different modelling and formula techniques, but you must be able to use them correctly and simultaneously. When it comes to the output that

Continue reading

How To Create Budgets With Seasonality Impact Using Power BI

I’m going to show you something specific and quite advanced on budgeting through Power BI. We’re going to dive into how to create budgets with consideration on seasonal impact.  This has great potential mostly because it paves the way for highly effective analysis. It also enables you to automate some of the insights that you

Continue reading