Documentation
-
Date.WeekOfYear - PowerQuery M
Learn more about: Date.WeekOfYear
-
Learn more about: Date.AddWeeks
-
Date.StartOfWeek - PowerQuery M
Learn more about: Date.StartOfWeek
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Date.WeekOfMonth(dateTime as any, optional firstDayOfWeek as nullable number) as nullable number
Returns a number from 1 to 6 indicating which week of the month the date dateTime
falls in.
dateTime
: A datetime
value for which the week-of-the-month is determined.Determine which week of March the 15th falls on in 2011.
Usage
Date.WeekOfMonth(#date(2011, 03, 15))
Output
3
Documentation
Date.WeekOfYear - PowerQuery M
Learn more about: Date.WeekOfYear
Learn more about: Date.AddWeeks
Date.StartOfWeek - PowerQuery M
Learn more about: Date.StartOfWeek