DATEADD function (DAX) - not showing post year 2000 calculations

[ManEff]

Hello - I was wondering if anyone had experienced an issue with DATEADD function and calculations NOT showing post year 2000 dates. My new column calculation appears to work (using the following formula to add 5 years to a start date):

Halfway = DATEADD(Plans[Start Date],+5,year)

but as can be seen in the table below the calculation only appears to work for resulting calculated dates pre the year 2000.

Hope that makes sense. Any experience/assistance to resolve this would be appreciated. Thanks, Tom.

[amitchandak · Accepted solution]

@ManEff , DATEADD needs continuous dates. so if the date is not there in the table/calendar table it will not show data. You can use the date as dateadd, if needed

date(year(Plans[Start Date])+5,month(Plans[Start Date]), day(Plans[Start Date]))

https://www.youtube.com/watch?v=YWo-ZpKM6gU