Category: Scenario Analysis

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

Develop Advanced Scenario Analysis Models Using DAX in Power BI

I really wanted to showcase here how incredible Power BI is as an analytical tool. You can achieve so much that you might never have thought possible. Developing scenario analysis logic within Power BI models is probably my favourite technique to use, mainly because it can be so valuable to business. Rather than just looking

Continue reading