Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |