Union only selected columns in new table

[Anonymous]

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?

[ryan_mayu · Accepted solution]

@Anonymous 

maybe you can try

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

[Anonymous]

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

[ryan_mayu]

you are welcome.