Tag: Profit Margins

Developing Sensitivity Analysis Logic Using DAX in Power BI

Sensitivity Analysis Logic Using DAX in Power BI

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

Continue reading

Calculating Percent Profit Margins Using DAX In Power BI

Working out your profit margins in Power BI with a basic data set can seem like it requires a few steps. Maybe you think you need to use calculated columns to get the result. Well, you certainly don’t need to do that. There is a much simpler way. Using measures, you can start with simple

Continue reading