Tag: DAX Power BI

Quick Measures Power BI: Year-To-Date Total Calculation

In this guide, I’ll briefly discuss how to use Quick Measures in Power BI. Quick Measures allows you to create DAX measures using a point-and-click method. Additionally, it enables you to quickly explore a lot of different formulas and formula combinations. Before I dive in, I just want to say that I don’t personally use

Continue reading

What Is DAX? Understanding Its Meaning, Importance And Use

Once you understand transformations and data modeling, you can finally start working on visualizations on your reports. This would require a deeper understanding of DAX. What Is DAX? What is DAX and why is it important? DAX stands for Data Analysis Expressions. DAX is the formula language within Power BI. This is where Power BI’s

Continue reading

Power BI DAX Formula Technique: Showcasing Growth Performance Effectively

Showcasing Growth Performance Effectively In Power BI - Advanced DAX

I want to share with you a Power BI DAX formula technique to show growth performance effectively.  In this tutorial, I’m going to demonstrate how it’s done, but there are so many different scenarios where you want to represent growth and this is just one example. The technique that I’m going to go through can

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

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