How to obtain year + 1 of any date

[o59393]

Hi all

How can I obtain a date with the following year for any given date using calculated columns?

For example if I have a date 4/14/2019, how can I have returned 4/14/2020?

Summing 365 to 4/1/4/2019 would be the most obvious thing to do, but this year we had a leap.

Thanks.

[v-eachen-msft]

Hi @o59393 ,

Do you have a date dimension? You could use CALENDAR() function to create a date dimension and make relationships between this table and fact table. Then you could use DATEADD() to get year+1.

[jdbuchanan71]

@o59393 

Try this.

Next Year Date = DATE ( YEAR ( [Date] ) +1, MONTH ( [Date] ), DAY ( [Date] ) )

Or this.

Next Year Date = DATEADD ( YourTable[Date], 1, YEAR )

[o59393]

Hi @jdbuchanan71 

I got this error:

How can I solve it? The Start of month is in date format.

Thanks.

[jdbuchanan71]

Does your [StartMonth] column contain a date?

[o59393]

Yeap:

Thanks!

[jdbuchanan71 · Accepted solution]

Try it wth the DATEADD instead.

Next Year Date = DATEADD ( [StartMonth], 1, YEAR )