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.
I import three tables that all contain a UniquRef. I want to be able to create a query that gives me all of the UniqueRef's from all of the three tables in one column then grouped so as to have just one instance.
I have tried to create (created querys to get my three tables down to one column of UniqueRefs) a New Table using UNION but I am then unable to query this New Table to group the resultant UniqueRef.
Can you point me in the right direction, I feel Im perhaps approaching this all wrong
As always, your patience and advice is greatly received.
Solved! Go to Solution.
Please try this solution, click the thumbs just for me helping you and click solved if it fixes your problems. Cheers !
There are other ways to answer your problem, but the trick here is to use Append and Remove Duplicates, rather than Group.
Many thanks speedramps. Have a great weekend, I will......now !!
Please try this solution, click the thumbs just for me helping you and click solved if it fixes your problems. Cheers !
There are other ways to answer your problem, but the trick here is to use Append and Remove Duplicates, rather than Group.
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 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |