Tag: Advanced DAX

Implementing 80/20 Logic in Your Power BI Analysis

Have you ever heard of the Pareto Principle? Another name for it is the 80/20 Rule. The rule stipulates that for every 20% of something, you’ll generally receive 80% of the results. So if we look at this from a business perspective, we’re saying that 20% of our customers should make up 80% of our

Continue reading

Customer Attrition Analysis – Advanced DAX in Power BI

We’re going to get advanced today. We’re going to really dive deep into customer churn: new customer and lost customer analysis. Now another name for this is attrition analysis because we want to see how our customer are churning, how many of our customers are coming on board and buying our products, how many are

Continue reading

Create Dynamic Lists of Dimensions using DAX in Power BI

Have you ever wanted to showcase the top three, five, or ten best results across a particular dimension? Well, in this video I’m going to show you exactly how you can do that with a specific example. The example we’re going to work through is one where I want to find my top three salespeople

Continue reading

Implement Ranking Logic Across Unique Insights with Power BI – Advanced DAX

The idea behind this tutorial is to show you how we can get to a very unique insight with Power BI, but do it in an intuitive way. I’m going to focus in on margin growth in the sales of an organisation, but take it even further and rank all salespeople on how they performed

Continue reading