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 - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources Enterprise DNA Membership - https://enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/ ***** Related Links ***** Using Multi-Layered Scenario Analysis in Power BI https://blog.enterprisedna.co/layering-multiple-what-if-scenarios-using-dax-in-power-bi/ Scenario Analysis Techniques Using Multiple 'What If' Parameters https://blog.enterprisedna.co/scenario-analysis-techniques-using-multiple-what-if-parameters-advanced-dax/ Advanced Analytics in Power BI: Layering Multiple 'What If' Analysis https://blog.enterprisedna.co/layering-multiple-what-if-parameters-for-advanced-analytics-in-power-bi/ ***** Related Course Modules ***** Scenario Analysis Series http://portal.enterprisedna.co/p/scenario-analysis-series Solving Analytical Scenarios w/Power & DAX http://portal.enterprisedna.co/p/solving-business-scenarios-with-power-bi-and-dax Advanced Data Transformations & Modeling http://portal.enterprisedna.co/p/advanced-data-transformation-and-modeling ***** Related Support Forums ***** Advice On Data Modeling https://forum.enterprisedna.co/t/advice-on-data-modeling/4343 Data Modelling? https://forum.enterprisedna.co/t/data-modelling/1296 Multiple Conditions Scenario Analysis https://forum.enterprisedna.co/t/multiple-conditions-scenario-analysis/5576 For more data model queries to review see here….. https://forum.enterprisedna.co/search?q=data%20model