CODEWITHSUNDEEP
powerbidax
variable
variable

Reputation: 9684

How to add a year in a calculated column?

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?

Upvotes: 0

Views: 1675

Answers (1)

Olly
Olly

Reputation: 7891

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] )
    )

Upvotes: 1

Related Questions