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

Create Automated Lists Based On Ranking Calculations in Power BI

You might find a situation where across a range of different metrics you actually want to show the TopN of something. In the example I run through in this tutorial video, I’m going to show how dynamically we can place a filter on our set of clients that is determined by the ranking in a

Continue reading

New vs Existing Customers – Advanced Analytics w/DAX

If you’re an online retailer or a high frequency sales operation, then understanding your customer base, like if they are new customers or existing customers, is a really high quality insight. You’ll want to dive into this type of analysis because you need to evaluate if most of your sales are attributed to people who

Continue reading

Managing Seasonality in Budgeting Analysis – Advanced Power BI

Completing budgeting analysis in Power BI is unfortunately just not that easy. What I’m going to go through today is possibly the most advanced technique that you can get to with budgeting as we need to incorporate some seasonality into our budgeting numbers. I detail this quite extensively in the video tutorial, so there’s lots

Continue reading

Tracking Trends in Power BI Using DAX Formulas

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