Forum Discussion

oliverome's avatar
oliverome
Regular Visitor
2 years ago
Solved

DATEADD doesn't display dates in future

I'm trying to create a column with a DAX formula that calculates a new date based on dates in another column. For context, I am calculating when a a device needs servicing. If the last servicing was ...
  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    Dateadd function doesnot work for you as it takes the list of available dates from your date table. 
    For your requirement you can try creating a calculated column using the below pattern 
    DATE(Year(DateTable[Date]) + 3, Month(DateTable[Date]), Day(DateTable[Date])

    you can also do this in power query using Date.AddYears function 
    https://learn.microsoft.com/en-us/powerquery-m/date-addyears

tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
2 years ago

Dateadd function doesnot work for you as it takes the list of available dates from your date table. 
For your requirement you can try creating a calculated column using the below pattern 
DATE(Year(DateTable[Date]) + 3, Month(DateTable[Date]), Day(DateTable[Date])

you can also do this in power query using Date.AddYears function 
https://learn.microsoft.com/en-us/powerquery-m/date-addyears

  • oliverome's avatar
    oliverome
    Regular Visitor
    2 years ago

    Thank you! I had tried that before, but I see I put the +3 in the wrong place. It works now.