Forum Discussion

liudmila's avatar
liudmila
Frequent Visitor
5 years ago
Solved

DAX UNION does not work as expected

Hi, I need to create a table ,every row comes from different sources. first row from cube1, second row from cube2 etc. I created a custom table using UNION Customers=UNION(table1,table2,table3,ta...
Need Help
  • liudmila's avatar
    liudmila
    5 years ago

    Hi Anonymous  thank you very much  for your suggection.  It was sorted. UNION did not work for me so I found the example in internet and it solved my problem

    instead of using just Union (table1, table2,table3, table4) 

    I used Union(table21, table2,table3, SELECTCOLUMNS ( Table4, "Column1", Table4[Column1], "Column2", Table4[Column2], "Column3", Table4[Column3] ) and it works!!!!

     

    )

     

liudmila's avatar
liudmila
Frequent Visitor
5 years ago

Thank you for your suggestion, I don't know how i can avoid this step? Definitely  I'd like to make the model using the best options but  in internet I cannot find anything better.

 

I will create a simple it will take time 🙂  Thank you.

m3tr01d's avatar
m3tr01d
Continued Contributor
5 years ago

Exactly, of course, we can answer your original question related to Union but this won't solve the future issues you'll encounter if your Data model is not designed with best practices 🙂