DATE_BUCKET() - simplify analytics on datetime values — Microsoft Fabric Roadmap

Description

The `DATE_BUCKET()` function groups dates into buckets of arbitrary length and returns the starting date of each bucket. This function is particularly useful for performing analytics on datetime columns when you need to aggregate or group values by time intervals.The following example shows how to group the values into 2-week buckets and count the number of records in each bucket:<br/> ```SELECT date_period = DATE_BUCKET(WEEK, 2, updated), count = COUNT(*) FROM dbo.bing_covid19_data GROUP BY DATE_BUCKET(WEEK, 2, updated)```

📰 Related Blog Article

DATE_BUCKET() function in Fabric Data Warehouse (Generally Available)

🔗 blog.fabric.microsoft.com

Change History

2026-06-16

Restored to Roadmap
2026-06-16

Removed from Roadmap
2025-12-18

Release Status Planned -> Shipped
2025-10-31

Roadmap Item Added