DATEADD Returns a table that contains a column of dates, shifted either forward or backward in time by the specified number of intervals from the dates in the current context.




Dates – A column that contains dates.

Number_of_intervals – An integer that specifies the number of intervals to add to or subtract from the dates.

Interval – The interval by which to shift the dates. The value for interval can be one of the following: year, quarter, month, day

Return Value

A table containing a single column of date values.

Reference Data

DAX Functions / Time Intelligence Functions / DATEADD