In this unique example, I want to show you how you can take a historical trend and repeatedly project it forward. This particular example came to me from a question in the Enterprise DNA support forum. An Enterprise DNA member needed to carry out this analysis in the real world. They had to take historical
Tag: DAX Calculations
I wanted to be able to drill into a specific subset of my customers – in this particular case – I decided to delve into the top 20% as it was most relevant to my analysis, and follows on from a previous tutorial about the Pareto principle – also known as the 80/20 rule. Not
In this tutorial, I wanted to cover new customer sales and how you can discover this using Power BI. The calculation and logic that we utilize to work out our new customer sales (or revenue) is very similar to just working out the absolute number of new customers that we have. The only difference is that
The CALCULATETABLE function is an incredibly important DAX function to learn and understand well. Most of you who are just starting out with Power BI, have probably glanced over this particular function (I certainly did when I first started out using Power BI and writing DAX measures). It’s quite a complex function to understand and
In this example, I want to showcase how many new customers we have every month. It is certainly open to debate what you would classify as a “new customer” based on your organization or industry. However, regardless of your definition, the technique will be very similar to the example that I will walk you through.