EDATE DAX Function (Date and Time)
Returns the date that is the indicated number of months before or after the start date.
Syntax
Parameter | Attributes | Description |
---|---|---|
StartDate |
A date in datetime format that represents the start date. |
|
Months |
The number of months before or after start_date. |
Return values
» 1 related function
Examples
-- EDATE adds months to a date, -- EOMONTH does the same, and it also goes at the end of the month EVALUATE ADDCOLUMNS ( TOPN ( 10, VALUES ( 'Date'[Date] ), 'Date'[Date], ASC ), "EDATE, +1", EDATE ( 'Date'[Date], +1 ), "EDATE, -1", EDATE ( 'Date'[Date], -1 ), "EOMONTH, 0", EOMONTH ( 'Date'[Date], 0 ), "EOMONTH, +1", EOMONTH ( 'Date'[Date], +1 ), "EOMONTH, -1", EOMONTH ( 'Date'[Date], -1 ) ) ORDER BY 'Date'[Date]
Date | EDATE, +1 | EDATE, -1 | EOMONTH, 0 | EOMONTH, +1 | EOMONTH, -1 |
---|---|---|---|---|---|
2005-01-01 | 2005-02-01 | 2004-12-01 | 2005-01-31 | 2005-02-28 | 2004-12-31 |
2005-01-02 | 2005-02-02 | 2004-12-02 | 2005-01-31 | 2005-02-28 | 2004-12-31 |
2005-01-03 | 2005-02-03 | 2004-12-03 | 2005-01-31 | 2005-02-28 | 2004-12-31 |
2005-01-04 | 2005-02-04 | 2004-12-04 | 2005-01-31 | 2005-02-28 | 2004-12-31 |
2005-01-05 | 2005-02-05 | 2004-12-05 | 2005-01-31 | 2005-02-28 | 2004-12-31 |
2005-01-06 | 2005-02-06 | 2004-12-06 | 2005-01-31 | 2005-02-28 | 2004-12-31 |
2005-01-07 | 2005-02-07 | 2004-12-07 | 2005-01-31 | 2005-02-28 | 2004-12-31 |
2005-01-08 | 2005-02-08 | 2004-12-08 | 2005-01-31 | 2005-02-28 | 2004-12-31 |
2005-01-09 | 2005-02-09 | 2004-12-09 | 2005-01-31 | 2005-02-28 | 2004-12-31 |
2005-01-10 | 2005-02-10 | 2004-12-10 | 2005-01-31 | 2005-02-28 | 2004-12-31 |
Related articles
Learn more about EDATE in the following articles:
-
Previous year up to a certain date
This article describes how to compute previous year values up to a certain date. This is useful in case the data is presenting incomplete months or years. » Read more
Related functions
Other related functions are:
Last update: Oct 3, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/edate-function-dax