Complex 'What If' Analysis Example In Power BI Using DAX [2022 Update]

In this video, Sam showcases a few things that you can learn from a complex ‘What If' analysis scenario. Sam covers a range of DAX and Power BI techniques, and shows you how you can layer scenarios on top of each other to see the outcome of numerous ‘What If' that could occur in the real world.

***** Video Details *****
00:00 Introduction
02:33 Isolating products
03:22 Selected scenario sales
04:56 Non-selected scenario sales
06:00 Scenario performance

***** Learning Power BI? *****

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial

[scottwalker]

Thank your for this video. Fantastic This was precisely the scenario I've been struggling to create using What If parameters to target forecast cost of select Opportunities. Many thanks.

[bolanlife]

based on the setup for this dashboard you created here, do you know if it's possible to adjust multiple product names at different % changes all at the same time?

in the video you have here, you're adjusting either individual or group of product with the same %, but I'm wondering how I could apply different %'s to multiple products at the same time.

[tinaflemons]

Is the pbix file available in the portal also

[drtonys.]

This is great! You could set budgets going forward with forecasting.

[RelaxingGamingMusic]

Great Video as always Sam. Keep up the fantastic work :)

[StaicuLaurentiu]

Hi. Where I find to download the Pbix file please? Thanks

[Jim-cc]

Sam, great video. I have a Enterprise DNA Pro subscription. Can you point me to where I can find this solution? Thank you

[johnj]

Really good analysis video ! Similar to Trevor Embree I would like to only have the demand increase of all other products on the resellers sales that sell the selected products. I am having real complex totals problems and wondered if you could help ?

[QuentinYang-wdts]

Hi There! This is extremely useful! However, my company wants to add another layer of complexity, which is to have 2 or 3 different sets of selected Products and adjust their different price increase to see how that impacts the total sales. I am out of tricks here, and was wondering if you could provide any insight for this? Thanks!

[GandalfGuy]

Hey Sam - useful stuff again - thx! I'm struggling with a 'similar' scenario; less complex in that we don't need the "Demand" option however; on the Product side: we'd like to return the list of currently purchased (subscription) products by a single customer (similar to your list down the left of the report) but have a selectable "level" of discount (similar to your 'Price Change') for every Product on the list. The report will calculate the change in cost to the business and also the increase or decrease in overall cost to the customer. Super bonus if we could have a Quantity selection per listed product also. Any thoughts appreciated :)

[rodrik]

Great video! the only thing that im not following is what has the "All Sales" measure that is keeping only the page filter (Year 2016) and not the product filter. Without that explanation its hard to understand the logic for me. I will assumme something in the lines of:
All Sales =
CALCULATE(
[Total Sales],
ALL('Product'[Manufacturer])
)

[AchillesModern]

Wouldn't it makes sense that the product that gets a discount also gets an increase in sales? If your top product is given a -20% discount is it not included in the increase in demand with the "Non selected Sales" or is that discounted product still included with the increased bump? Interesting analysis either way.

I'd be interested in a top 25% products "What if" analysis. Either "What if" your customers looked like the top 25% average of customers and how much you would gain based off the number of customers... Or "What if" the top 25% price average of products and how much you would gain based off the number of products sold.

These what if analysis' are great! Keep up the good work!

[dritans]

Great explanation.
What software do you use for recording?

[fazalkadri]

the cinstant swallowing annoyed the hell out of me. I am sorry but couldnt get my head away from it.