cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lwklwk98
Helper I
Helper I

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

Hello! 

 

Here is a mock-up dataset:

 

Column A Column B 
Japan2
Korea4
Japan6
Korea1
Korea9

 

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 🙂

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi, @lwklwk98 

Please check the below for creating a new column.

 

Picture1.png

 

 

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


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.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

Hi, @lwklwk98 

Please check the below for creating a new column.

 

Picture1.png

 

 

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


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.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

Hey @Jihwan_Kim ,

 

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

 

Cheers!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!