Tag: Profit Margins

Find Your Top Clients Across Different Measures in Power BI

Here at Enterprise DNA, we are building an analytical movement with Power BI. Today, I am going to walk you through how you can create an awesome visualization where we dynamically showcase only our top ranked clients using multiple measures in Power BI. What we have here is a slicer which dynamically changes the visualizations

Continue reading

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