Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
So I've got two tables both with Account Manager columns, for example
Table 1:
Gary
Gary
Dave
Terry
Billy
Billy
Table2:
Jenny
Jenny
Dave
Billy
And i want to then create a new table with:
Gary
Dave
Terry
Billy
Jenny
I've tried using summarize and distinct but to no avail...
@DarylRob , Create a new table
Name=
distinct(union(distinct(Table1[Name]),distinct(Table2[Name])))
Perfect, thanks. But now i'm trying to create a relationship between the two fields but it won't create a many-to-one relationship instead only able to create a many-to-many. Any ideas?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
109 | |
89 | |
76 | |
66 |
User | Count |
---|---|
126 | |
112 | |
99 | |
82 | |
73 |