How to add days to date in power bi

Date.AddDays

• 07/29/2019
• 2 minutes to read
• • 
   
  • 
   
  • 
   
  • 

Syntax

Date.AddDays(dateTime as any, numberOfDays as number) as any  

About

Returns the date, datetime, or datetimezone result from adding numberOfDays days to the datetime value dateTime.

• dateTime: The date, datetime, or datetimezone value to which days are being added.
• numberOfDays: The number of days to add.

Example 1

Add 5 days to the date, datetime, or datetimezone value representing the date 5/14/2011.

powerquery-m

Date.AddDays(#date(2011, 5, 14), 5)

#date(2011, 5, 19)