Date.StartOfYear
1 January of the year a date falls in.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Date.StartOfYear(dateTime as any) as any| Parameter | Type | Description |
|---|---|---|
dateTime | any | A date, datetime or datetimezone value; null gives null. |
Returns
any. The same kind of value, on 1 January.
Remarks
- For a datetime or datetimezone the answer is at midnight, 00:00:00, with any offset kept.
Examples
The year of a sale
Date.StartOfYear(#date(2024, 8, 20))#date(2024, 1, 1)A datetime starts at midnight
Date.StartOfYear(#datetime(2024, 8, 20, 10, 0, 0))#datetime(2024, 1, 1, 0, 0, 0)Days since the year began, for year-to-date figures
Duration.Days(#date(2024, 8, 20) - Date.StartOfYear(#date(2024, 8, 20))) + 1233