Date.AddWeeks is a function in the Power Query M language that adds a specified number of weeks to a date or datetime value. The resulting value is returned as a date, datetime, or datetimezone.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Date.AddWeeks( dateTime as any, numberOfWeeks as number, ) as any
datetimezone result from adding
numberOfWeeks weeks to the
datetimezonevalue to which weeks are being added.
numberOfWeeks: The number of weeks to add.
Add 2 weeks to the
datetimezone value representing the date 5/14/2011.
// Output: #date( 2011, 5, 28 ) Date.AddWeeks( #date( 2011, 5, 14 ), 2 )
Other functions related to Date.AddWeeks are: