DAX Patterns

Description

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. Introduction Chapter 1 Time-related calculations Chapter 2 Standard time-related calculations Chapter 3 Month-related calculations Chapter 4 Week-related calculations Chapter 5 Custom time-related calculations Chapter 6 Comparing different time periods Chapter 7 Semi-additive calculations Chapter 8 Cumulative total Chapter 9 Parameter table Chapter 10 Static segmentation Chapter 11 Dynamic segmentation Chapter 12 ABC classification Chapter 13 New and returning customers Chapter 14 Related distinct count Chapter 15 Events in progress Chapter 16 Ranking Chapter 17 Hierarchies Chapter 18 Parent-child hierarchies Chapter 19 Like-for-like comparison Chapter 20 Transition matrix Chapter 21 Survey Chapter 22 Basket analysis Chapter 23 Currency conversion Chapter 24 Budget About the authors