DAX Patterns

ABC Classification – Dynamic

The dynamic version of the ABC Classification pattern is an extension of the Dynamic Segmentation pattern. It groups items (such as Products or Custom…
See more on daxpatterns.com



Most popular whitepapers





 
Latest articles

Computing same product sales in DAX

This article shows a technique in DAX to compute the sales volume of products that were available right from the beginning of a selected time period, ignoring products introduced afterwards.


How to handle BLANK in DAX measures

This article describes a counterintuitive behavior of BLANK in DAX measures affecting Power BI, Analysis Services, and Power Pivot. That behavior could cause mistakes in a report using alternate expressions of the same calculation. Indeed, these expressions are not equivalent when BLANK is involved.


Using KEEPFILTERS in DAX

This article explains how to use KEEPFILTERS to intersect instead of overriding an existing filter context in DAX, simplifying the code and improving performance.


Start learning DAX for free

SQLBI offers a new introductory DAX video course called Introducing DAX. This article describes which users will benefit more from this learning experience, and how to enroll in the course.

Page 1 of 1312345...10...Last »