Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Union only selected columns in new table

Hi there

 

I have two tables - Table1 and Table 2. Both hold columns called [User ID] and [User Name].

I want to create a dim table holding unique values of these two columns.

 

I could use the long-winded way of unioning both tables, keeping only those two columns and removing duplicates, but I expect there is a more efficient way of doing this I don't know about.

 

I have tried creating a new table in Dax using UNION(DISTINCT - but I only know how to pull in one column into this table. 

Any ideas?

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    maybe you can try

    Table 2 = UNION(SUMMARIZE('Table','Table'[userid],'Table'[username]),SUMMARIZE('Table (2)','Table (2)'[userid],'Table (2)'[username]))

     

     

3 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    5 years ago

    Anonymous 

    maybe you can try

    Table 2 = UNION(SUMMARIZE('Table','Table'[userid],'Table'[username]),SUMMARIZE('Table (2)','Table (2)'[userid],'Table (2)'[username]))

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks Ryan this worked perfectly. I will adopt this in future now for Dim Tables 🙂