Tag: Data Analysis

Custom Dynamic Segmentation Using DAX In Power BI

In this blog post, I want to go over an advanced DAX pattern about how to create custom dynamic segmentation in Power BI. You can apply this great technique to many scenarios to gain meaningful insights. Dynamic groups are created when a range of different customers are segmented based on different metrics like sales, margin

Continue reading

Projecting The Current Trend in Your Power BI

In this unique example, I want to show you how to project a historical trend in Power BI and repeatedly project it forward. This particular example came from a question in the Enterprise DNA support forum. An Enterprise DNA member needed to carry out this analysis in the real world using historical information, which could

Continue reading

How to Maximize The Use of INTERSECT Function – Advanced DAX

The INTERSECT function in Power BI is an advanced table function and you need to understand it better so you can maximize the use of this advanced DAX. But to understand how it works, you need to get much better at understanding virtual tables. Virtual tables are a key concept when utilizing DAX measures within

Continue reading

Implementing DAX Measure Groups Into Your Reports – A Power BI Modeling Review

In this tutorial, I’ll be talking about a really important topic regarding Power BI modeling and organization. In most of the demos that Enterprise DNA releases across webinars, summits, and to Enterprise DNA members, you will see that the use of measure groups is extensive. There is a very good reason why measure groups have

Continue reading

Fixing Incorrect Totals Using DAX Measures In Power BI

Getting totals correct inside Power BI reports can sometimes be the most frustrating thing when utilizing DAX measures. You might probably get into certain situations where your Totals for DAX measures aren’t adding up the way you want them to.  DAX measures can be based on standard aggregation functions, such as COUNT or SUM. These

Continue reading