Develop Advanced Scenario Analysis Models Using DAX in Power BI

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 favorite technique to use, mainly because it can be so valuable to the business.

Rather than just looking backward and reporting on historical information, what you can do with scenario analysis is almost predict the future. You can pull levers in your metrics and across your data and see how it impacts the final results. The opportunities become endless!

Almost any dataset that looks to explore information over time can use this technique or a form of the techniques that I go through in the video.

I also go into measure branching, how to use parameter tables, how to insert variables into measures, and much more.

This is quite advanced but very achievable. It just takes a lot of practice and also really putting your mind into your data, and thinking hard about the sort of insights you want to test around your future results. Try to identify the variables sitting in your datasets or calculations that you could ‘shock’ or tweak to review their impact on your underlying performance.

Good luck with this one. Be sure to try to get some of these techniques into your models so you embed the concepts in your mind and take them even further.

***** Learning Power BI? *****
All Enterprise DNA TV Resources
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online


***Learn more about Enterprise DNA Membership***membership banner 3

10 comments on “Develop Advanced Scenario Analysis Models Using DAX in Power BI”

  1. Wow, very impressive Sam and just the thing I’m looking to achieve albeit on the cost side but steps should be the same.


  2. Hi Sam

    Really enjoying learning from your vids. By far and away you and Ruth are the best learning method that works for me.

    Been replicating your YT vid on how to compare accounting periods when DATEADD is unsuitable. However, would really appreciate your thoughts on a method of linking an accounting period into the date table based on a link to a Period Table?
    e.g. For my organisation, a five week period for, say, Nov 2017 would range between 30/10/17 – 03/12/17. (The ‘from’ and ‘to’ date would be columns in a ‘Period’ Table.)

    Would there be any method you can think of that can link any date (on the date table) to the period table so a ‘Period’ can be returned that I can filter or measure against etc?

    Hope this makes sense and any ideas would be appreciated.


    Steve (UK)

    1. Hi Steve, I would attempt to get those period into the date table by merging them. You want one date table with on the detail in it. Very similar to the example that I run through in the video. I think it becomes to complex it you have other table, when simplifying it shouldn’t be to difficult inside the query editor

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.