Counting Customers Over Time – DAX Example in Power BI

In this example I’m going to run through how you can calculate how many customers you sell to through time using a few functions inside of Power BI in the DAX language. There are actually a few ways you can calculate it, which is why I wanted to create a short tutorial on it to

Continue reading

Segment Your Customers Into Groups – Advanced DAX Example

I’m getting complex today with DAX, but that’s because I enjoy showcasing the power of this formula language inside of Power BI. I want you to get there too. It’s why I always want to get practical around implementation. This is a perfect example of a really valuable commercial insight you can extract out of

Continue reading

Detailed Ranking Example Using DAX in Power BI

Power BI is an amazing analytical engine! Today I’m going to show you how you can find your top customers – not just as static numbers, but through time and through any time period you could want. This is the power of DAX combined with the data model at its best. In this example I

Continue reading

Developing Sensitivity Analysis Logic Using DAX in Power BI

We’re getting specific today and really showcasing the analytical power of Power BI. Sensitivity analysis, or even running some ‘what ifs’ around this, allows you to almost predict what may happen in the future with your results. In this example I want to see what will happen to my profitability if I am able to

Continue reading