Merging two columns from two tabels into one column

[pbzmz]

I've got 2 columns in 2 different tabels but my data in the table are complementary.

As i show you on this screenshot.

And i want to merge them to one column, but i doesn't exacly know how to do it.

[v-yadongf-msft · Accepted solution]

Hi @pbzmz ,

If your two tables have the same number of columns, consider using the UNION() function.

My test table1:

My test table2:

Please try following DAX:

Table = UNION('Table1','Table2')

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lukiz84]

Do you load them in PowerQuery? Tell us a little more about the structure 🙂

[pbzmz]

In K3513 i have one column called "cena" and in the K3510 i have other column called "cena".

And in !Miary, "Tabela", i want to create new column that will merge those two column that i just mention

[lukiz84]

Have you tried this?

Merge queries and join tables (microsoft.com)

[pbzmz]

After doing same thing from this video it's showing me column full of zeros.

[lukiz84]

Is "Tabela" empty or are there already values in it? Where does Tabela come from?

[pbzmz]

I've managed to merge both files in excel so I have everything in one table now.

But i have one additional question. My column named "cena", has numbers in it, and when i throw them to matrix, it shows me column "cena" as sum. And I don't want it

[lukiz84]

That's normal (implicit measure). 

See Explicit Vs Implicit DAX Measures in Power BI - RADACAD

If you want to just have the value in your Matrix you have to format it as Text or create a Measure which you then place on the matrix. The Measure can be something like MIN(Cena) or TEXT(cena, "0000")

[lukiz84]

Hi,

-In DAX: Create a new Calculated column:

MergedColumn := IF([Col1]<>BLANK(), [Col1], [Col2])

-In PowerQuery: Add a custom column:

Table.AddColumn(tbl, "MergedColumn", each if [Col1] <> null then [Col1] else [Col2])

[pbzmz]

It's good if i have two columns in one table. But i've got two columns. Two different files. And i need to merge one column from one file, and one column from second file.