Tag: DAX Calculations

Create Compelling Power BI Insights Fast For Financial Analysis

Learn Where Your Profit Comes From Fast in Power BI wSimple DAX

In this particular example, I’m going to show you how you can discover profit insights quickly with Power BI. Profits are key for any business, right? You want to understand how your profits are being derived, where they’re coming from, and why you’re getting the results that you are. With Power BI, using intuitive techniques,

Continue reading

Automatically Find Your Top 3 Salespeople Per Region Using DAX In Power BI

Create Dynamic Lists of Dimensions using DAX in Power BI

There’s so much you can do with DAX in Power BI, and one of these things is for you to be able to find your top 3 salespeople for each region automatically. Picture this too familiar scenario…. You are in a meeting and asked about your sales territories. Who are your top three sales people

Continue reading

Discover Where Your Profit Growth Comes From: A Power BI Tutorial

In this Power BI tutorial, 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 similar elements in your

Continue reading

How To Organize Your Power BI Data Model – Best Practice Tips

BEST PRACTISE TIPS FOR MODEL ORGANIZATION

I wanted to highlight in this post some of my best practice tips for Power BI data modelling. In this tutorial, I go through many techniques in detail which I think you’ll find very beneficial as soon as you start implementing these into your reports. You’ll find that as you work through any development, certain

Continue reading

Comparing Calculated Columns And Measures In Power BI

Measures vs Calculated Columns In Power BI

In this tutorial, I will cover the two places where you can write your DAX formulas. These two places are the calculated columns and measures. I will go over each one at a time and I’ll start with calculated columns. Using Calculated Columns A calculated column is an additional column that doesn’t exist in your

Continue reading