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.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains RANGE in context, with comparison tables and the common traps.
Terms in this definition
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
- Span
One operation inside a trace, such as a single LLM call or prompt flow node, carrying attributes plus start and end times. Nested spans reveal the order of calls.
- PREVIOUS
Fetches the value of the preceding element along an axis of the visual matrix. This DAX function works only in visual calculations and is equivalent to OFFSET with -1.
- WINDOW
Returns rows from a sorted, optionally partitioned table, either at fixed positions (ABS) or relative to the current row (REL). Running totals plus moving averages are common uses.
Related terms
- Access restrictions
Allow and deny rules for inbound App Service traffic, matched on IP range, service tag or subnet. They can, for instance, restrict an app to a corporate NAT's public addresses.
- Applicability rules
Let a Windows device configuration profile target or skip devices by their OS edition or by a version range, using Assign profile if or Don't assign profile if.
- Application segment
Destination defined on an enterprise application for Microsoft Entra Private Access, made up of an FQDN, wildcard FQDN, IP or range together with ports and protocol. Matching traffic is reachable solely by users assigned to that app.
- Autoscaling
A classic compute option where you give a minimum and maximum worker count and Azure Databricks adjusts the number of workers within that range to match the load.
- Azure CNI Overlay
AKS networking option where pods draw IPs from a private overlay range and VNet addresses are consumed only by nodes; it works with Windows nodes.
- BRIN
Short for block range index, a PostgreSQL index that keeps a summary for each range of table blocks. It is compact and works well on very big tables where values track the physical order of rows, timestamps being a typical case.
- CALENDARAUTO
Scans the model for its first and last dates and returns a continuous Date column covering complete calendar years, or fiscal years when you pass a year-end month. As later dates arrive through refresh, this DAX function's range grows to include them.
- Client address pool
Range of private addresses handed out to point-to-site VPN clients; it must not overlap on-premises or VNet ranges and is set once the VPN gateway has been created.