Tag: Advanced DAX

Power BI Grouping Technique: Aged Trial Balance Using DAX

We’re going to explore a really unique Power BI grouping or segmentation example in this tutorial. We’ll create an aged trial balance grouping inside Power BI. This technique involves re-using many of the grouping and segmentation patterns that we already learned. Utilizing Power BI grouping patterns for this unique example is no different. The idea

Continue reading

Identify & Showcase Data Outliers In Power BI Using DAX

We are going to take Power BI development to the next level and discover important new trends in our data. First, we need to dive into our data outliers through some advanced logic in Power BI using DAX. I’ll help you understand the difference between raw and filtered contexts. So, we’re going to analyze and

Continue reading

Data Segmentation Based On Percentage Groups – Advanced DAX In Power BI

I’m going to go over quite an advanced data segmentation technique in this tutorial, which is around grouping data in a dynamic way inside Power BI. In this tutorial, we’re going to specifically look at just this particular visualization in this dashboard I used during a Learning Summit around customer insights. In this case, we’re

Continue reading

Creating Power BI Tables By Using UNION & ROW Function

I’m going to show you how you can create Power BI tables using a formula that combines the UNION function and the ROW function. There are many ways to create Power BI tables but in this case, I will show you a powerful technique that can provide you with valuable information and insights. To create

Continue reading

Power BI Customer Segmentation: Showcasing Group Movement Through Time

This tutorial is all about customer insights. I will demonstrate an advanced Power BI customer segmentation technique using DAX formulas and a secondary table. Identifying or segmenting customers is a technique in itself, but comparing customer segments in the current period and in a prior period is another great technique. We can get some real

Continue reading