DateTable=CALENDARAUTO()
Calculated columns:
NextYearDate = DATEADD(DateTable[Date],1,YEAR)
The above calculated column shows blanks instead of the next years date. Why is that and how to fix it?
>Solution :
DATEADD is a Time Intelligence function, which returns dates from your date column shifted by the specified interval. This means that for the latest year in your date table, there are no "next year" values to return.
An alternative would be:
NextYearDate =
DATE (
YEAR ( DateTable[Date] ) + 1,
MONTH ( DateTable[Date] ),
DAY ( DateTable[Date] )
)