DAX Patterns by SQLBI

  • Home
  • Patterns
  • Book
  • Videos
  • About
  • Home
  • Patterns
  • Book
  • Videos
  • About

Patterns are solutions

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.

See all patterns
Patterns for Power BI / Excel
  • Time patterns
  • Standard time-related calculations
  • Month-related calculations
  • Week-related calculations
  • Custom time-related calculations
  • Comparing different time periods
  • Semi-additive calculations
  • Cumulative total
  • Related distinct count
  • Parameter table
  • Static segmentation
  • Dynamic segmentation
  • ABC classification
  • Budget
  • Survey
  • Basket analysis
  • New and returning customers
  • Currency conversion
  • Hierarchies
  • Parent-child hierarchies
  • Events in progress
  • Like-for-like comparison
  • Transition matrix
  • Ranking

Time intelligence

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.

Discover our time patterns

More patterns for common use cases

Other patterns are crucial when you need to:
  • Understand how many customers are new or returning;
  • Calculate running totals for your monthly data;
  • Represent the charts of accounts;
  • Analyze which products are frequently purchased together.

Watch the videos

Accept cookies to show this video. Cookies Policy
Allow all cookies
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.
2006-2023 © SQLBI. All rights are reserved. SQLBI is a trademark of SQLBI Corp.   PRIVACY POLICY & COOKIES

Power BI and Excel are trademarks of Microsoft Corp. Amazon, Kindle, and all related logos are trademarks of Amazon.com, Inc. or its affiliates. Apple Books is a service mark of Apple Inc. Google Books is a trademark of Google LLC.

  • SQLBI
  • DAX Guide
  • DAX.do
  • DAX Patterns
  • DAX Formatter
  • Bravo for Power BI
  • OKVIZ