Forum Discussion

Regular Visitor

3 years ago

Solved

Adding a number to column from an IF statement

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 ...

Need Help

Show and Tell

serpiva64
3 years ago
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!