Tag: DAX formula

Explore Forecasting Logic In Your Power BI Models Using DAX

Explore Forecasting Logic In Your Power BI Models Using DAX

It doesn’t get more real world than the video below for an application of Power BI to provide great insight. In the example I run though here, I want to compare my actual results to my forecasted results. Not only that – I want to view these cumulatively. The cumulative totals give me a much

Continue reading

Discover How To Repeatedly Project A Current Trend Forward In Power BI

Discover How To Repeatedly Project A Current Trend Forward In Power BI

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

Continue reading

Discover The INTERSECT Function In DAX And How To Utilize It – Power BI Tutorial

Discover The INTERSECT Function In DAX And How To Utilize It - Power BI Tutorial

The INTERSECT function in Power BI is an advanced table function and to understand how it works, you will want to get much better at understanding virtual tables. Virtual tables are a key concept when utilizing DAX measures within Power BI. What the INTERSECT function does specifically is that it allows you to – within a

Continue reading

Who Are Your Top 20% Of Customers Based On Any Metric – Quality Power BI Insights

Who Are Your Top 20% Of Customers Based On Any Metric - Quality Power BI Insights

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

Continue reading

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

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