Tag: DAX Calculations

How To Organize Your Power BI Models – Best Practice Tips

I wanted to highlight in this post some of my best practice tips when organizing detailed Power BI models. You’ll find as you work through any development, elements of your Power BI reports will grow. This can be things like new tables of data, differing relationships between tables, an assortment of measure groups and much

Continue reading

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

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

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

Deep Dive Into The CALCULATETABLE Function – An Important DAX Formula To Understand Well

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

Continue reading