Create a new Column to change Value in Column B given a conditional value of Column A

[lwklwk98]

Hello! 

Here is a mock-up dataset:

Column A	Column B
Japan	2
Korea	4
Japan	6
Korea	1
Korea	9

What I need to do is to create a new column that will multiply the values of Column B by 2 if the country in Column A is Korea, while retaining the original value of Column B for Japan.

I really appreciate any help! Thank you so much 🙂

[Jihwan_Kim · Accepted solution]

Hi, @lwklwk98 

Please check the below for creating a new column.

New Column CC =
SWITCH (
TRUE (),
'Table'[Column A ] = "Korea", 'Table'[Column B ] * 2,
'Table'[Column B ]
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[lwklwk98]

Hey @Jihwan_Kim ,

Thanks so much for your help! It worked like a charm 🙂

Cheers!