Category: DAX

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

Discovering Advanced Insights in Power BI – Free Workshop Preview

For the first webinar series session of the year I thought I would dive into some more advanced concepts around Power BI development. To learn more about the event and to register click here – Webinar Registration To get advanced in Power BI you first have to start using DAX formulas. Hopefully this is a

Continue reading