Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Merging two columns from two tabels into one column

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...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi Anonymous ,

     

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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

    • lukiz84's avatar
      lukiz84
      Icon for Memorable Member rankMemorable Member
      3 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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