Date.StartOfYear is a Power Query M function that returns the start of the year that contains the specified date(Time). Your input must be a date, datetime, or datetimezone value.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Date.StartOfYear( dateTime as any ) as anyDescription
Returns the start of the year that contains dateTime.
dateTime must be a date, datetime, or datetimezone value.
Examples
Find the start of the year for October 10th, 2011, 8:10:32AM.
// Output: #datetime( 2011, 1, 1, 0, 0, 0 )
Date.StartOfYear( #datetime( 2011, 10, 10, 8, 10, 32 ) )Related articles
Learn more about Date.StartOfYear in the following articles:
- Create Date Table or Calendar in Power Query M
Learn how to create a dynamic calendar table in Power Query’s M language. Build your custom columns and claim your free Date Table Script. » Read more
Related functions
Other functions related to Date.StartOfYear are:
