Are Margins Expanding Or Contracting? Solve in Power BI

Here I’m diving into a relatively specific insight, but by walking through exactly how I got there, you will learn so much about what you can do with Power BI and DAX. I really dive into this concept of ‘measure branching‘, which I love implementing. It’s all about layering measures one on top of the

Continue reading

Tracking & Showcasing Trends In Power BI using DAX

Power BI and DAX Video Tutorial Tracking and Visualising Trends Analysis

Showing trends and how they change over time can add a lot of value to your consumers and decision makers. In this example I show you how you can use the conditional formatting inside Power BI tables to showcase this type of insight really well. Obviously to show growth trends we actually need to calculate

Continue reading

Discover Where Your Profit Growth Comes From in Power BI

In this example I dive into what’s perhaps a very niche insight. But don’t let that close you off to using this technique  – there are plenty of ways to implement this across a range of scenarios. The key is to understand each different part and transfer them across to similar elements in your own

Continue reading

Advanced Segmentation Example Using DAX in Power BI

When you get more and more into DAX formulas, you will see the world of analytical opportunities immeasurably expand for you. In this example I show you by just how much. I’m going to combine some pretty advanced DAX logic and then build upon it by combining the initial calculation with another one. This is

Continue reading

My 3 Best Practice Tips For Organizing Power BI Models

Today I’m going to run through my best practice tips for organizing your Power BI models. Trust me when I tell you that placing some good organization rules into your models is going to help you immensely as you start developing more advanced techniques inside of Power BI. If I was to give you one

Continue reading