Date.DayOfYear
The day's number within its year: 1 for 1 January, up to 365 or 366.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Date.DayOfYear(dateTime as any) as nullable number| Parameter | Type | Description |
|---|---|---|
dateTime | any | A date, datetime or datetimezone value; null gives null. |
Returns
nullable number. The day of the year.
Examples
The first of March in a leap year
Date.DayOfYear(#date(2024, 3, 1))6131 days of January and 29 of February come first.
New Year's Eve
Date.DayOfYear(#date(2024, 12, 31))366