article –
RANKX on multiple columns with DAX and Power BI
This article shows techniques to obtain a ranking based on more than one column. The ranking can be both static and dynamic. Read more
article –
Formula engine and storage engine in DAX
This article explains the roles of the formula engine and of the storage engine used to execute DAX queries. Read more
Feb 3-5 - New York City
Feb 17-19 - Sydney
Video Training
Introducing DAX Video CourseFree
article –
Dynamic format strings with calculation groups
This article shows two techniques based on calculation groups: how to implement dynamic format strings in regular measures, and how to perform weight conversion on the fly. Read more
article –
Set functions in DAX: UNION, INTERSECT, and EXCEPT
This article describes the behavior of the DAX functions that manipulate sets; they are useful to create queries and sometimes also to author measures. Read more
DAX Patterns
Transition matrix
The Transition matrix pattern analyzes changes in an attribute assigned to an entity at regular intervals For example customers might receive a ranking evaluation every month or products might have a rating score measured every week Measuring the changes in… www.daxpatterns.com
Book –
SQLBI Corp.
DAX Patterns, Second Edition
A pattern is a general, reusable solution to a frequent or common challenge.
This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel. Read more