Forum Discussion

shefalinishad11's avatar
shefalinishad11
Icon for Helper I rankHelper I
5 years ago
Solved

Create unique table from two tables

Hi Team,   I am trying to create a new unique employee table with column, name id, name, rank, country. The two other tables are table1 & table2, both tables have the same 4 fields with the other 1...
Interesting Links
Need Help
Tips and Tricks
  • PoojaDarbhe's avatar
    PoojaDarbhe
    5 years ago

    Hi shefalinishad11 ,

     

    You can create a measure like below

     

    testcustomTab = DISTINCT(UNION(SELECTCOLUMNS(table1, "ID", table1[ID], "Name", table1[name]),SELECTCOLUMNS(table2, "ID", table2[id], "Name", table2[name])))
     
    Let me know in case of any help.
     
    Best regards,
    Pooja Darbhe
PoojaDarbhe's avatar
PoojaDarbhe
Icon for Resolver I rankResolver I
5 years ago

Hi shefalinishad11 ,

 

You can create a measure like below

 

testcustomTab = DISTINCT(UNION(SELECTCOLUMNS(table1, "ID", table1[ID], "Name", table1[name]),SELECTCOLUMNS(table2, "ID", table2[id], "Name", table2[name])))
 
Let me know in case of any help.
 
Best regards,
Pooja Darbhe