Forum Discussion
DATEADD function (DAX) - not showing post year 2000 calculations
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):
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.
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
1 Reply
- amitchandak
Super User
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