Power BI Analysis Using DAX: How Many Unique Products A Customer Bought

In this Power BI analysis example, we’re going to generate a unique insight where we’re going to evaluate all our customers and see how many unique products they bought. I’ll show you how to analyze this over time and use anything in the data model.  For this Power BI analysis, we’ll evaluate the data in

Continue reading

Counting Customers Over Time Using DISTINCTCOUNT In Power BI

In this blog post, I’m going to run through how you can calculate how many customers you sell to through time using a few functions such as DISTINCTCOUNT inside of Power BI. 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

Power BI Data Sets: Learn How To Detect Abnormal Behavior Using DAX

In this blog post, I will show you in detail how you can discover abnormal patterns of behavior within your Power BI data sets. This is not something that will immediately stand out when running analysis across your data so you have to think quite analytically about it. By thinking deeply about what you want to

Continue reading