← All updates Databricks Update One-Pager Navy version
databricks Platform · Updated Sep 14, 2026

Window measures on a numeric index column in metric views

Window measures support unitless offset and trailing/leading ranges on a consecutive integer order column.

What it does

Window measures support unitless offset and trailing/leading ranges on a consecutive integer order column. Use a numeric index for non calendar periods such as fiscal weeks or 4 4 5 periods. Advanced techniques for metric views let you express complex business logic and reuse definitions across your semantic layer.

Why it matters

Reduces operational overhead and unlocks new capabilities for data teams on Databricks.

Key capabilities
name: date expr: oorderdate
name: date expr: oorderdate
name: t7dcustomers expr: COUNT(DISTINCT ocustkey)
name: t7dcustomers expr: COUNT(DISTINCT ocustkey)
order: date range: trailing 7
order: date range: trailing 7 day semiadditive: last
name: date expr: oorderdate
name: date expr: oorderdate
Architecture
Databricks Platform → Platform
In short

Window measures support unitless offset and trailing/leading ranges on a consecutive integer order column. Use a numeric index for non calendar periods such as fiscal weeks or 4 4 5 periods.

Read the full documentation ↗
Key takeaway
Window measures support unitless offset and trailing/leading ranges on a consecutive integer order column.
2026-09-14-window-measures-on-a-numeric-index-column-in-metric-views Generated by the Databricks Updates Agent · browse all updates