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

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's avatar
lukiz84
Icon for Memorable Member rankMemorable Member
3 years ago

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")