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.
Solved! Go to Solution.
I'm sure there is a power query / M way of doing this, but I'm a dax nerd. I'd use "Calculate Table" with
NewTable = UNION(DISTINCT(Table1[Email]), DISTINCT(Table2[Email])
I'm sure there is a power query / M way of doing this, but I'm a dax nerd. I'd use "Calculate Table" with
NewTable = UNION(DISTINCT(Table1[Email]), DISTINCT(Table2[Email])
@Anonymous Thanks !!. This worked for me .Thank you
Think I need to become a DAX nerd! Thanks scottsen, worked a treat!
I just added another DISTINCT before UNION to make sure only one email address was returned if the same email address was in both tables.
Thanks!
Mike
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |