How to combine values from 2 columns

[LINUS_MAASTOK]

I everyone!
i have a problem, I want to create a single column from the combination of 2 others from diferent tables...
these columns have a null value or a numerical value, like this:

COLUMN_TABLE1--COLUMN_TABLE2 ----- WANTED COLUMN_FROM_ANY_TABLE
(null)---------------(null)-----------------------(null)
(null)---------------8832-----------------------8832
2131----------------(null)----------------------2131
(null)----------------(null)---------------------(null)
3324-----------------3324---------------------3324
2232-----------------(null)---------------------2232

BTW, IM working on Power BI. Also, excuse me for my bad english uwu

 

[Gerald Higgins]

Is it POSSIBLE that you could have an entry like this ?

COLUMN_TABLE1--COLUMN_TABLE2
2131-------------8832

And if the answer is "YES", how do you want to handle it ?

 

[LINUS_MAASTOK]

its imposible... if both tables have numerical values are the same

 

[sandy666]

maybe
Table.AddIndexColumn(Table.RemoveColumns(Source,{"COLUMN_TABLE1"}), "Index", 1, 1)

Table.AddIndexColumn(Table.RemoveColumns(Source,{"COLUMN_TABLE2"}), "Index", 1, 1)

merge by Index
then double IF

 

[billszysz]

Assuming that your data is in Table1 and Table2

let
    Source = Table.FromColumns({List.Transform(List.Zip({Excel.CurrentWorkbook(){[Name="Tabela1"]}[Content][Column1], Excel.CurrentWorkbook(){[Name="Tabela2"]}[Content][Column1]}), each List.Max(_))})
in
    Source