Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

edate dax

EDATE is used when you want to add some number of months to a single date
instead of a column (for which you would use DATEADD)

syntax: EDATE(startDate, numMonths)
returns startDate + numMonths months

examples:
EDATE(18/07/2022, 1) returns 18/08/2022
EDATE(18/07/2022, -1) returns 18/06/2022
EDATE(30/01/2022, 1) returns 28/02/2022 -- edge case for Jan 29th, 30th and 31st
 
PREVIOUS NEXT
Tagged: #edate #dax
ADD COMMENT
Topic
Name
6+8 =