Category: Scenario Analysis

Discover How Many Sales Can Be Attributed To New Customers – Advanced Power BI Insights

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

Continue reading

Calculate The Total Of New Clients You’re Onboarding Every Month – Advanced DAX

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.

Continue reading

Calculate Consecutive Weekday & Weekend Days In Power BI Using DAX

We’re going to work through something really unique around Time Intelligence inside of Power BI. This scenario was brought up on the Enterprise DNA Support Forum, where there was a need to compare “like-for-like” within months. In other words, they wanted to compare the first working day in a particular month to the first working

Continue reading

Predicting Future Results – Next Free Power BI Training Workshop

In the next free Power BI training workshop being put on by Enterprise DNA we are going to be diving deep into some prediction analysis. You can learn more and register for the event here Predicting Future Results in Power BI What I wanted to do was take a very real-world situation and look to

Continue reading

How To Start Using ‘What If’ Parameters Inside Power BI

In this tutorial, I will show you how you can get started with ‘What If’ parameters inside of Power BI. Using this great feature will require you to spend some time thinking quite deeply about the data setup that you currently have in your data model. ‘What If’ parameters have to work over certain values

Continue reading