Forum Discussion
Solved
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 form...
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
amitchandak
Super User
Super UserManEff , 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