databricks Databricks Release Notes ·

Databricks: Window Measures Support Numeric Index Columns in Metric Views

analyticsdatabricksengineer
feature

Databricks has enhanced window measures in metric views to support unitless offset and trailing/leading ranges. This update enables the use of consecutive integer order columns, facilitating analysis over non-calendar periods such as fiscal weeks or 4-4-5 periods. The change allows for greater flexibility in defining time-based aggregations for data professionals.

Features (1)
  • Window Measures Support Numeric Index Columns for Flexible Periods

    Window measures now support unitless offset and trailing/leading ranges when used with a consecutive integer order column. This enables users to define custom non-calendar periods like fiscal weeks or 4-4-5 periods for their metric view calculations.

Read the original announcement →

https://docs.databricks.com/aws/en/release-notes/product/2026/september#window-measures-on-a-numeric-index-column-in-metric-views

Related releases