Tag: Profit Margins

Show Changes Over Time In Power BI Reports

In this Power BI Showcase, we’re going to focus on time intelligence in Power BI to showcase how our business metric changes over time. We have a reseller of a product that’s being sold throughout the East Coast of Australia. We want to analyze all their key metrics which includes Sale and Profits among other

Continue reading

Calculating Dynamic Profit Margins – Easy Power BI Analysis With DAX

Calculating Dynamic Profit Margins - Easy Power BI Analysis With DAX

I want to go over how to calculate dynamic profit margins in Power BI. This is something I consider to be quite straightforward if you’ve been using Power BI for some time. But if you’re just starting out, this could be challenging to piece together. This kind of information is something that most organizations need.

Continue reading

Averages Per Customer Transactions – DAX in Power BI

What I want to demonstrate in this tutorial is how we can calculate the average amount of sales, profits, or transactions per certain dimension inside of DAX in Power BI. In this particular example we’re going to look at it from a customer’s perspective. We’re going to try and analyze what the average sales are

Continue reading

Use Power BI Measure Branching To Check If Your Margins Expand As Revenue Grows

In this post, we’re going to look at an analytical insight where we find out if our profit margins grew together with our revenue. We can do this through the use of Power BI measure branching. This is important because we want to see if revenue expansion or getting the market share is actually good

Continue reading

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