Category: DAX

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 Unique Insights Using Power BI TOPN Function

In this video, I wanted to find an insight that was really unique, and hugely valuable for business. Here, I used the Power BI TOPN function. I wanted to know the best-selling day for every single product. Not only that, I wanted to be able to look dynamically into any store and analyse the best-selling

Continue reading

Using Iterating Functions SUMX And AVERAGEX In Power BI

One of the most crucial topics for any Power BI beginner to know about is iterating functions. So before you dip your head in working with complex calculations, I will share with you some simple iterating functions in this article. Why Use Iterating Functions? I get this question all the time as I do live

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