Date.EndOfWeek is a Power Query M function that returns the end of the week, with an optional parameter to set the first day of the week. The function returns the end of the week as a date, datetime, or datetimezone value.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Date.EndOfWeek(
dateTime as any,
optional firstDayOfWeek as nullable number,
) as anyDescription
Returns the end of the week that contains dateTime. This function takes an optional Day, firstDayOfWeek, to set as the first day of the week for this relative calculation. The default value is Day.Sunday.
dateTime: Adate,datetime, ordatetimezonevalue from which the last day of the week is calculatedfirstDayOfWeek: [Optional] A Day.Type value representing the first day of the week. Possible values are Day.Sunday, Day.Monday, Day.Tuesday, Day.Wednesday, Day.Thursday, Day.Friday and Day.Saturday. The default value isDay.Sunday.
Examples
Get the end of the week for 5/14/2011.
// Output: #date( 2011, 5, 14 )
Date.EndOfWeek( #date( 2011, 5, 14 ) )Get the end of the week for 5/17/2011 05:00:00 PM -7:00, with Sunday as the first day of the week.
// Output: #datetimezone( 2011, 5, 21, 23, 59, 59.9999999, -7, 0 )
Date.EndOfWeek( #datetimezone( 2011, 5, 17, 5, 0, 0, -7, 0 ), Day.Sunday )Related articles
Learn more about Date.EndOfWeek 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.EndOfWeek are:
