Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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?

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@Anonymous 

maybe you can try

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

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@Anonymous 

maybe you can try

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

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

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

you are welcome.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.