DAX Patterns, 2/e (Paperback)

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.

一個模式是對於頻繁或常見挑戰的一般可重複使用的解決方案。這本書是 DAX 最全面的可立即使用解決方案的第二版，您可以在 Microsoft Power BI、Analysis Services Tabular 和 Power Pivot for Excel 中使用。

本書包含以下模式：與時間相關的計算、標準與時間相關的計算、與月份相關的計算、與星期相關的計算、自定義與時間相關的計算、比較不同時間段、半可加計算、累計總計、參數表、靜態分割、動態分割、ABC 分類、新與回頭客戶、相關不同計數、進行中的事件、排名、階層、父子階層、同期比較、轉換矩陣、調查、購物籃分析、貨幣轉換、預算。