Power Query
published
Search
K
Comment on page

Date.StartOfWeek

Date.StartOfWeek

Returns the first value of the week.
function (optional dateTime as nullable any, optional firstDayOfWeek as nullable any) as nullable any

Description

Returns the first value of the week given a date, datetime, or datetimezone value.

Category

Date

Examples

Find the start of the week for October 10th, 2011, 8:10:32AM (#datetime(2011, 10, 10, 8, 10, 32)).
Date.StartOfWeek(#datetime(2011, 10, 10, 8, 10, 32))

datetime(2011, 10, 9, 0, 0, 0)