Tag: DAX formula

Using The ALL Function In Power BI For High Quality Insights

This video tutorial shows you how you can use the ALL Function in Power BI to showcase unique insights. Think about this one from a deeper analytical perspective. We’re going to dive into the average order size for sales we may be making across a variety of different products. If you’re selling to a lot

Continue reading

Using Ranking DAX Measures To Extract Unique Insights In Power BI

In this example, I wanted to analyse something really practical. I wanted to work out the total sales of my top 3 salespeople based in any region. A really interesting insight, right? It might seem relatively intuitive but actually implementing this inside of Power BI is not that easy. You need to understand how to

Continue reading

Isolating Weekday or Weekend Results Using DAX in Power BI

Sometimes calculating averages per day in your Power BI reports isn’t actually enough. You might run into a scenario where you only actually sell during weekdays. You might be a retailer or a restaurant where you only sell in a specific period of days. Now, if you go and run an averaging pattern in Power

Continue reading

Budgeting Scenarios In Power BI Using DAX

So we’re going to really dive into some problem-solving here. This is some really great stuff that you can do with Power BI, but if we just step back for a moment, the key here is, first of all, you’ve got to be able to think analytically. And that’s what I want to do initially.

Continue reading