We have just published two new videos by Alberto Ferrari, world-renowned BI and DAX expert from sqlbi.com. They teach you about three critically important patterns in DAX: banding (eg. prices), new-vs-old computation (eg. sales to new vs returning customers), and the all-important concept of working with many-to-many relationships. The first video, Many-to-many Relationships in DAX, is short and free!—have a look at it if you have ever wondered how to use a many-to-many relationship in Data Analysis Expressions.

However, to learn it all, you ought to watch Alberto’s in-depth, 50-minute DAX Patterns: Banding, New vs Old, Many-to-many video. This tutorial is available to all Full Access Members, and is part of our DAX online course, which is growing all the time, as Alberto, and his colleague, Marco Russo, add new modules.