A pattern is a general, reusable solution to a commonly occurring business problem.
For example, you can use the Ranking pattern if you have sales data in Power BI or Excel and want to know the ranking position of the products you have sold so far.
The most popular patterns are about time-related calculations.
Time patterns are useful to calculate year-to-date values in your Power BI reports, to compare amounts over different periods of time, to calculate a rolling average over 12 months in Excel worksheets, and more.
Do you learn better by watching videos? For each pattern, you will find an in-depth video lecture recorded by DAX experts. Watch now
Read the book
Do you prefer having an offline copy of the patterns?
We collected all of them into a book. Get your copy now
Why DAX patterns?
Because all the patterns collected on this website are written in DAX, which is the programming language of Power BI, Analysis Services Tabular, and Power Pivot for Excel.
Marco Russo and Alberto Ferrari are the experts behind the content of daxpatterns.com. In recent years, they have taught more than 300 classes on DAX around the world and written best-selling books such as The Definitive Guide to DAX.