Forum Discussion

shefalinishad11's avatar
shefalinishad11
Helper 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
AlB's avatar
AlB
Community Champion
5 years ago

Hi shefalinishad11 

You can do this best in PQ.

Simply append both tables and then remove duplicates. See it all at work in the attached file.

let
    Source = Table.Combine({Table1, Table2}),
    #"Removed Duplicates" = Table.Distinct(Source)
in
    #"Removed Duplicates"

 

 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.