DAX Patterns, 2/e (Paperback)

Russo, Marco, Ferrari, Alberto

  • 出版商: Sqlbi Corp.
  • 出版日期: 2020-08-10
  • 售價: $1,650
  • 貴賓價: 9.5$1,568
  • 語言: 英文
  • 頁數: 420
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1735365203
  • ISBN-13: 9781735365206
  • 相關分類: ExcelPower BI大數據 Big-data
  • 相關翻譯: DAX 設計模式, 2/e (簡中版)
  • 立即出貨 (庫存=1)



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 分類、新與回頭客戶、相關不同計數、進行中的事件、排名、階層、父子階層、同期比較、轉換矩陣、調查、購物籃分析、貨幣轉換、預算。