Tag: CALCULATE

Introduction To Advanced DAX in Power BI

In this tutorial I want to show you some samples of Advanced DAX calculations in Power BI. After going through the basics, I’ll now demonstrate some advanced functions and formulas that are key to computing more complicated calculations. I won’t cover every formula or function, but instead I’ll give you an overview of a few

Continue reading

Advanced Product Budgeting – Actual Results To Budgets Per Product

I’m going to go over something specific in product budgeting. It’s quite advanced but if you can understand the concepts and the techniques that I go through here, you’ll also have a good understanding of what Power BI can do, how DAX works, and how you can combine a lot of different functions to get

Continue reading

Break Out New Customer Sales – Advanced Power BI Insights

In this tutorial, I wanted to go over new customer sales and teach you how to calculate it using your Power BI model. When you’re working out who your new customers are, you first of all need to make sure you have a sound understanding of how you classify a new customer. The calculation and

Continue reading

How to Compare Current Sales to Previous Best Month in Power BI

In this tutorial, we’re going to learn more about the advanced time intelligence feature in Power BI to compare current sales to the previous best month. This is actually a unique question that was raised at the Enterprise DNA Support Forum. And as soon as I heard it, I thought wow! We can actually do

Continue reading

Attrition Analysis: Finding Lost Customers Using Power BI & DAX

In this tutorial, we’re going to focus on some customer attrition analysis in Power BI. Power BI is an amazing tool for high-quality analytics. In my view, it doesn’t have a close competitor at this point in time. The dashboard we’re using here is part of the Learning Summit I had on attrition analysis, but

Continue reading