Watch the 2022 Update of this video here: youtu.be/YdBvLjo-akY
Scenario analysis is all about predicting what outcome could occur in the future. I'm a huge promoter of this type of analysis in Power BI. This is what really makes a big difference and adds real value to your organisations.
In this example, I showcase many steps around layering scenario variables into your analysis. Good luck with this!
*****Video Details*****
0:16 - Introduction
1:54 - How To Layer Scenarios
5:18 - Using The Cumulative Pattern
7:11 - Conclusion
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
Using Multi-Layered Scenario Analysis In Power BI
blog.enterprisedna.co/layering-multiple-what-if-scenarios-using-dax-in-power-bi/
Scenario Analysis Techniques Using Multiple 'What If' Parameters
blog.enterprisedna.co/scenario-analysis-techniques-using-multiple-what-if-parameters-advanced-dax/
Develop Advanced Scenario Analysis Models Using DAX in Power BI
blog.enterprisedna.co/advanced-scenario-analysis-techniques-for-power-bi-wdax/
***** Related Course Modules *****
Advanced Analytics in Power BI
portal.enterprisedna.co/p/advanced-analytics
Scenario Analysis Series
portal.enterprisedna.co/p/scenario-analysis-series
Scenario Analysis Deep Dive
portal.enterprisedna.co/p/scenario-analysis-deep-dive
***** Related Support Forums *****
Scenario Analysis on Specific Attributes - What If Parameters Setup, Power BI
forum.enterprisedna.co/t/scenario-analysis-on-specific-attributes-what-if-parameters-setup-power-bi/363
Advanced Scenario Analysis Techniques For Power BI w/DAX
forum.enterprisedna.co/t/advanced-scenario-analysis-techniques-for-power-bi-w-dax/572
What If Scenario For Each Item
forum.enterprisedna.co/t/what-if-scenario-for-each-item/2624
For more multiple scenarios queries to review see here…..
forum.enterprisedna.co/search?q=multiple%20scenarios
- Extending Layered Scenario Analysis Techniques - Advanced DAX & Power BI ( Download)
- Was Revenue Growth Profitable - Analysis In Power BI w/DAX ( Download)
- Predict Profitability For Future Time Periods - DAX & Power BI ( Download)
- Complex 'What If' Analysis Example In Power BI Using DAX ( Download)
- Learn Where Your Profit Comes From Fast in Power BI w/Simple DAX ( Download)
- Sensitivity Analysis Example in Power BI using DAX ( Download)
- Creating Budgets With Seasonality Adjustments Automatically - Power BI Technique ( Download)
- Solving in Power BI Which Products Have Contributed Most to Profit Growth using DAX ( Download)
- Did Margins Expand As Revenue Grew - Power BI & DAX Critical Analysis ( Download)
- How To Calculate Percent Profit Margins In Power BI ( Download)
- Answer If Margins Are Expanding or Contracting Through Time With Power BI ( Download)
- Dynamic Results vs Budgets & Last Year - Power BI Financial Reporting Techniques ( Download)
- Find Your Top 3 Salespeople Per Region Automatically in Power BI using DAX ( Download)
- How To Use Variables in DAX Formula with Power BI ( Download)
- Using The Extended Date Table - ISAFTERTODAY ( Download)
