Category: Power BI

Find Your Top Products For Each Region in Power BI Using DAX

If you are a business selling products in many different stores or across many different regions, then you will want to understand if there is any commonality in your top or bottom selling products. You would want to discover your top products per region. You may watch the full video of this tutorial at the

Continue reading

Creating Forward Forecasts in Power BI Using DAX

How to Create Forward Forecasts in Power BI Using DAX

In this blog, we’re going to go over how you can create automated forecast from historic data in Power BI. This is common in businesses to make forecasts and budgets. You may watch the full video of this tutorial at the bottom of this blog. Now, have you ever wanted to create automatic forecasts based

Continue reading

Implementing The Pareto (80/20) Principle in Your Power BI Analysis

Have you ever heard of the Pareto Principle, also known as the 80/20 Rule? The rule stipulates that for every 20% of something, you’ll generally receive 80% of the results. You may watch the full video of this tutorial at the bottom of this blog. If we look at this from a business perspective, we’re

Continue reading

Counting Customers Over Time Using DISTINCTCOUNT In Power BI

Counting customers over time using distinctcount in power bi post image

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

Dynamic Segmentation: How To Segment Customers Into Groups Using Advanced DAX

Today, I’m getting complex with DAX, but that’s because I enjoy showing the power of this formula language inside Power BI. I want you to get there too. This is why I always want to get practical about implementation. Dynamic segmentation is a perfect example of a really valuable commercial insight you can extract out

Continue reading