Create new column having the values of existing 2 columns

[Prabhu11]

Hi Community,

I want to create a column with the values of Column 1 and Column 2 as column 3,

How can I achieve this, kindly help

Column 1	Column 2	Column 3
A	0	A
B	0	B
0	C	C
0	0	0
0	D	D

Regards

Prabhu

[Anonymous]

Hi,
By combining, do you mean concatinating?
Then you can use: 

Combined = 'Table'[Column 1] & " " & 'Table'[Column 2] & " " & 'Table'[Column 3]

[Prabhu11]

Hi, I don't need to concatenate, I trying to achieve through the condition

i.e If Column 2 has value then return the value of Column 2 else return the value of Column 1 in the final Column 3

[Anonymous · Accepted solution]

Oh okay, my bad!
here is a solution to that:

Outcome = SWITCH(TRUE(),

'Table (2)'[Column1] = "0" && 'Table (2)'[Column2]="0", 'Table (2)'[Column1],

'Table (2)'[Column1]="0" && 'Table (2)'[Column2] <>"0", 'Table (2)'[Column2],

'Table (2)'[Column1] <> "0" && 'Table (2)'[Column2] ="0", 'Table (2)'[Column1])