Adding a number to column from an IF statement

[Jon8930]

Hi,

I am trying to create a custom column using an if statement to report the following:

= each if [Asset Type] = "PC Tower" then [Year of Purchase] + 5 else 0

I want it to add 5 years to the "Year of purchase" based on its asset type.

This returns an error and need some help where I am going wrong.

Many Thanks

Jon

[serpiva64 · Accepted solution]

Hi,

each is wrong.

I have tried the following

if [FromCurrency]= "GBP" then [Year]+5 else [Year]

and it function.

in the formula bar it appears this way

= Table.AddColumn(#"Added Custom1", "Custom", each if [FromCurrency]= "GBP" then [Year]+5 else [Year])

pay attention to the type of your Year column

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!

[Jon8930]

Sorted it, Many thanks for your help.

Jon