date.addYears showing "right paren expected" in IF statement

[stsau]

Hi Expert,

based on a condition I want to create a new data column by adding 1 year to an existing column.

My (simple) formula is

= if ( ([Portfolio]="IAM") then Date.AddYears([End of Committed Support],1) )

The Date function is giving an error, open/close parenthesis should be OK.
Why am I getting the error?

[Jimmy801]

Hello @stsau 

you are missing the else-statement

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[stsau]

thanks for the hint, but unfortunately that doesnt change the error

[Jimmy801 · Accepted solution]

Hello @stsau 

I didn't see that you used parents parenthesis for the if-syntax. the syntax is     if check then true else false

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[stsau]

ok, solution is to remove the outer brackets, thanks for your hints