Date.DayOfYear

This function will return a numerical value that indicates the specific day of the year based on the inputted date, datetime, or datetimezone value within the dateTime parameter.

Syntax

Date.DayOfYear(dateTime as any) as nullable number

About

This function will return a numerical value that indicates the specific day of the year based on the inputted date, datetime, or datetimezone value within the dateTime parameter.

Explanation

The Power Query function MDate.DayOfYear(#date(2011, 03, 01)) is used to determine the numerical day of the year for the date March 1st, 2011. The output of this function is 60, indicating that March 1st is the 60th day of the year in 2011.