Understanding window functions in DAX
summary
Covers practical DAX window functions with concrete demos showing when they simplify code or hurt performance: index picks absolute positions (positive from top, negative from bottom) and requires unique rows or ties resolve deterministically; offset and window compute relative ranges and produce unions when multiple values exist; apply semantics explains how row and filter contexts merge so a function without a table uses allselected of the orderby columns; shows partitioning, ranking differences, and debugging tips.
AI-written summary · about
chapters (22)
- 0:00Introduction to DAX windows
- 2:24Understanding index function
- 3:28Index function practical demo
- 7:00Handling ties in indexing
- 8:21Addressing duplicated rows
- 11:52Implementing partitions
- 13:21Partition demo and use cases
- 14:59Implicit table arguments
- 16:40Context transition in DAX
- 19:42Introduction to offset
- 21:44Applying offset semantics
- 25:46Offset practical demo
- 31:00Analyzing complex filters
- 34:02Internal behavior of offset
- 36:29Using offset for comparisons
- 37:20Introduction to window
- 39:14Window partition analysis
- 41:43Window function applications
- 42:56Rank and row number functions
- 43:25Comparing rank and row number
- 44:59Debugging complex DAX
- 48:26Fixing and wrapping up
related talks
32mWindowing Functions for Database Analytics
01mWindowing Functions for Database Analytics
57mTop 10 Excel Formulas for Analysts
54mData Visualization with Power View and the Tabular Model
51mPower BI Composite and Hybrid Models
01h 01mDark Matter: Domain Experts & Nextgen Spreadsheets Are Our Future
01h 03mBudgeting with Power Pivot
01h 00mMastering the CUBE Functions in Excel 2013