Jovan Popovic makes an announcement:
We have introduced a new DATE_BUCKET() function in Fabric Data Warehouse SQL language that makes reporting and analytics even easier.
In this blog post, you’ll discover how it simplifies time-based reporting and makes grouping dates effortless.
My experience is that DATE_BUCKET() takes a bit of effort getting used to, as it is not an intuitive function. That said, it can be really powerful for dealing with time series data. It is also available in SQL Server, as of SQL Server 2022.