Date.DayOfYear is a Power Query M function that returns a number representing the day of the year in the provided date, datetime, or datetimezone value. The function returns the day of the year as an integer.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Date.DayOfYear( dateTime as any ) as nullable number
Returns a number representing the day of the year in the provided
The day of the year for March 1st, 2011.
// Output: 60 Date.DayOfYear( #date( 2011, 03, 01 ) )
Learn more about Date.DayOfYear 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
Other functions related to Date.DayOfYear are: