Tag: What If Analysis

Using ‘What-If’ Parameters in Power BI

What-If parameters are a really powerful feature to implement in your models for scenario analysis. Scenario analysis is immensely important from an analytical perspective in Power BI and ‘What-If’ parameters allow you to quickly implement tables and measures for this type of analytics. Once you select the What-If parameter icon, it opens a popup box

Continue reading

Multiple ‘What If’ Parameter Handling In Power BI

Do you want to see how advanced you can get with Power BI? I want to show you here what would most likely be my favourite way to use Power BI. Not just because of what insights you can find, but also the ease of which you can implement this analysis compared to what it

Continue reading

Scenario Analysis Techniques Using Multiple ‘What If’ Parameters – Advanced DAX

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

Layering Multiple ‘What If’ Scenarios Using DAX in Power BI

I’m huge on scenario analysis in Power BI. Being able to input variables inside your calculations that you can ‘shock’ to effectively predict outcomes is so powerful when trying to make decisions. In Power BI you can complete this really efficiently, and you can combine many of the formula techniques with your data models and

Continue reading