Tag: Sensitivity Analysis Logic

Sensitivity Analysis Examples in Power BI

By Sam McKay, CFA on May 10, 2020June 10, 2022

Sensitivity Analysis Logic Using DAX in Power BI

I want to dive deeper and show you the ways of implementing some sensitivity analysis examples in your Power BI model. You may watch the full video of this tutorial at the bottom of this blog. Sensitivity analysis is a very important financial model. It helps businesses in predicting the outcome of a certain scenario,

Posted in: Data Modeling, Financial Reporting, Power BI, Profit Margin Analysis, Profit Prediction, Scenario Analysis, Scenarios Analysis, Sensitivity Analysis, Sensitivity Analysis Logic, What If Analysis, What If Parameters, What If Scenario Analysis

Data Visualization DAX Power BI Scenario Analysis

Developing Sensitivity Analysis Logic Using DAX in Power BI

By Sam McKay, CFA on December 23, 2019May 9, 2022

We’re getting specific today and really showcasing the analytical power of Power BI. Sensitivity analysis, or even running some ‘what ifs’ around this, allows you to almost predict what may happen in the future with your results. In this example, I want to see what will happen to my profitability if I am able to

Posted in: Advanced DAX, Measure Branching, Profit Margin Analysis, Profit Margins, Scenario Analysis, Sensitivity Analysis, Sensitivity Analysis Logic, What If Analysis