DAX Patterns 2015

A pattern is a general reusable solution to a commonly occurring problem. This book is a collection of ready-to-use data models and formulas in DAX, that you can use in Power Pivot for Excel and in Microsoft Analysis Services Tabular.
Create your data model faster by using a DAX pattern!

The patterns published in the book are also available in the DAX Patterns website. The book format makes them available offline, too!

Table of Contents:

  1. Introduction
  2. DAX Fundamentals
  3. Time Intelligence Functions
  4. Time Patterns
  5. Cumulative Total
  6. Related Distinct Count
  7. Statistical Patterns
  8. Parameter Table
  9. Static Segmentation
  10. Dynamic Segmentation
  11. ABC Classification
  12. Handling Different Granularities
  13. Budget Patterns
  14. Survey
  15. Basket Analysis
  16. New and Returning Customers
  17. Parent-Child Hierarchies
Written by -
Get the book     
DAXPatterns2015-front-cover-ibooks

Get the book

North America United States
Canada
Mexico
South America Brazil
Europe United Kingdom
Ireland
Germany
France
Italy
Spain
The Netherlands
Asia China
India
Japan
Oceania Australia
Other countries


Enclose code in comments with <PRE></PRE> to preserve indentation.