{"active":true,"blog_title":"DATE_BUCKET() function in Fabric Data Warehouse (Generally Available)","blog_url":"https://blog.fabric.microsoft.com/en-us/blog/date_bucket-function-in-fabric-data-warehouse","feature_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/>\n```SELECT          date_period = DATE_BUCKET(WEEK, 2, updated),        count = COUNT(*) FROM dbo.bing_covid19_data  GROUP BY DATE_BUCKET(WEEK, 2, updated)```","feature_name":"DATE_BUCKET() - simplify analytics on datetime values","last_modified":"2025-12-18","product_id":"fa3a73cd-dcd6-ee11-9079-000d3a310f67","product_name":"Data Warehouse","release_date":"2025-12-08","release_item_id":"d33a4d87-58b6-f011-bbd3-000d3a5b0efa","release_status":"Shipped","release_type":"General availability"}