DAX Patterns

<p>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.</p><p>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.</p>