Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
@Anonymous
maybe you can try
Table 2 = UNION(SUMMARIZE('Table','Table'[userid],'Table'[username]),SUMMARIZE('Table (2)','Table (2)'[userid],'Table (2)'[username]))
Proud to be a 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]))
Proud to be a Super User!
Thanks Ryan this worked perfectly. I will adopt this in future now for Dim Tables 🙂
you are welcome.
Proud to be a Super User!
User | Count |
---|---|
106 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |