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
Comparing different time periods
This pattern is a useful technique to compare the value of a measure in different time periods For example we can compare the sales of the last month against a user-defined period The two time periods might have a different… 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