DAX Patterns, 2nd Edition
DAX Patterns, 2nd Edition by Marco Russo, Alberto Ferrari
English | July 28, 2020 | ISBN: 1735365203 | True EPUB | 418 pages | 102 MB
English | July 28, 2020 | ISBN: 1735365203 | True EPUB | 418 pages | 102 MB
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.
The book includes the following patterns: Time-related calculations, Standard time-related calculations, Month-related calculations, Week-related calculations, Custom time-related calculations, Comparing different time periods, Semi-additive calculations, Cumulative total, Parameter table, Static segmentation, Dynamic segmentation, ABC classification, New and returning customers, Related distinct count, Events in progress, Ranking, Hierarchies, Parent-child hierarchies, Like-for-like comparison, Transition matrix, Survey, Basket analysis, Currency conversion, Budget.