Rolling 12 Months Average in DAX

Rolling averages over time (a.k.a. moving averages or running averages) are useful to smoothen chart lines and to make trends more evident. This article shows how to compute a rolling average over 12 months, in DAX.  Read more

DAX Patterns

Basket analysis

The Basket analysis pattern builds on a specific application of the Survey pattern The goal of Basket analysis is to analyze relationships between events A typical example is to analyze which products are frequently purchased together This means they are…  More on DAX Patterns


SQLBI Corp.

DAX Patterns, Second Edition

A pattern is a general, reusable solution to a frequent or common challenge.
This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel. Read more