Rolling 12 Months Average in DAX

Rolling averages (a.k.a. moving averages or running averages) over time 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

Standard time-related calculations

In this pattern we show you how to compute time-related calculations like year-to-date same period last year and percentage growth using a standard calendar The great advantage of working with a standard calendar is that you can rely on several…  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