The time intelligence function creates calculations that use built-in knowledge about calendars and dates. You can build meaningful comparisons across comparable periods for sales, inventory, etc. by using time and date ranges in combination with aggregations or calculations.
Description
The DATEDIFF function returns a date, shifted either forward or backward in time by the specified number of intervals from the dates in the current context.
Syntax
DATEADD(<dates>,<number_of_intervals>,<interval>)
Parameters
Return Value
A date or datetime value.
Example
DATEADD('Sale'[SaleDate],1,YEAR)