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
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.
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!
We love business intelligence and over the years have gained deep knowledge about Microsoft BI technologies that we want to share with you.