Popular Use Cases

What is a pattern?

A pattern is a general reusable solution to a commonly occurring problem.
In Microsoft Excel, you use patterns every day to build tables, charts, reports, dashboards, and more.

DAX Patterns is a collection of ready-to-use data models and formulas in DAX, which is the programming language of Power Pivot. Create your Excel data model faster by using a DAX pattern!

Are you looking for a way to calculate inventory stock based on the history of inventory movement?
No problem, use our Cumulative Total pattern!

Looking for something else?

Designed for Microsoft Excel, PowerPivot, and Analysis Services

Microsoft Excel

We provide sample workbooks in Excel for all the patterns. Versions are available for Excel 2010 and Excel 2013, so no need to convert them.

You also can use the DAX patterns in the Analysis Services Tabular model. Just create a new project by importing the PowerPivot data model included in the sample Excel files provided with the DAX pattern.

Dax Reference Book

We are collecting all the patterns in a book!

Soon we will offer a book with all the patterns on this web site, for easy reference. We will announce it as soon as we have a release date. Stay tuned!

Want to be updated when new patterns are published?
Subscribe to our newsletter:


This site is produced by

SSAS Maestro by MicrosoftWe are Microsoft Most Valuable Professionals (MVPs) and Certified Trainers, and have achieved SSAS Maestro level, the highest Microsoft certification on SQL Server Analysis Server.
We have written books on Analysis Services, Excel and PowerPivot.
We organize Advanced DAX, Excel PowerPivot, and SSAS Tabular courses all over the world.

Advanced DAX  Workshop
Okay, we are all geeks!

We love business intelligence and over the years have gained deep knowledge about Microsoft BI technologies that we want to share with you.