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
Date.EndOfWeek( dateTime as any, optional firstDayOfWeek as nullable number, ) as any
Returns the end of the week that contains
dateTime. This function takes an optional
firstDayOfWeek, to set as the first day of the week for this relative calculation. The default value is
datetimezonevalue from which the last day of the week is calculated
firstDayOfWeek: [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 is
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 )
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
Other functions related to Date.EndOfWeek are: