Advanced Scenario Analysis Techniques For Power BI w/DAX

Review how to run simple and advanced scenario analysis techniques in Power BI. In this example we run through how you can dynamic 'shock' pricing and see how that impacts sales
****Video Details****
0:16 - Introduction
2:24 - Total Sales Using SUM vs Total Sales Using SUMX
4:20 - Creating A Supporting Table To Show Price Changes
5:42 - Harvesting The Price Change Percentage Selected
6:56 - Calculating Scenario Sales
7:52 - Showing All Sales Impact Of Selected Products
9:32 - Showing Results Of Selected Products
10:45 - Working Out The Master Calculation
12:37 - Branching Out Into More Measures
12:37 - Branching Out Into More Measures For More Insights
14:44 - Creating Compelling Visualizations To Showcase The Results
16:43 - Conclusion
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ulti...
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-...
FREE - Power BI Resources - enterprisedna.co/power-bi-reso...
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-d...
**** Related Links ****
Using Multi-Layered Scenario Analysis in Power BI
blog.enterprisedna.co/layerin...
Scenario Analysis Techniques Using Multiple 'What If' Parameters
blog.enterprisedna.co/scenari...
Advanced Analytics in Power BI: Layering Multiple 'What If' Analysis
blog.enterprisedna.co/layerin...
**** Related Course Modules ****
Scenario Analysis Series
portal.enterprisedna.co/p/scen...
Solving Analytical Scenarios w/Power & DAX
portal.enterprisedna.co/p/solv...
Advanced Data Transformations & Modeling
portal.enterprisedna.co/p/adva...
**** Related Support Forums ****
Advice On Data Modeling
forum.enterprisedna.co/t/advi...
Data Modelling?
forum.enterprisedna.co/t/data...
Multiple Conditions Scenario Analysis
forum.enterprisedna.co/t/mult...
For more data model queries to review see here…..
forum.enterprisedna.co/search...