An optional ROWS or RANGE BETWEEN ... AND ... part of OVER that narrows which partition rows each calculation considers. A running total, for example, runs from UNBOUNDED PRECEDING to CURRENT ROW.
Also called ROWS or RANGE frame.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Window frame in context, with comparison tables and the common traps.
Terms in this definition
- RANGE
Usable only in visual calculations, this DAX function picks a span of rows along an axis counted from the current one, say the previous six. Think of it as a simpler WINDOW, handy for moving totals.
- OVER
Gives a T-SQL window function its window: PARTITION BY, ORDER BY and, if wanted, a ROWS or RANGE frame. Rankings and running totals can then be worked out while every row is kept.
- Azure AI Search partition
Storage and I/O unit of a search service, each holding part of the indexes. Adding partitions increases storage and indexing throughput; the number of search units equals replicas multiplied by partitions.
- Agents (classic) API
First-generation Foundry Agent Service API, based on threads, messages and runs. It is deprecated, replaced by conversations and responses, and retires on 31 March 2027.