Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Goodmorning Everybody,
i need your precious help.
I have two tables.
The first one represents the communication and the groups to which it was transmitted.
IdCommunication | IdGroup |
1 | 5 |
1 | 6 |
1 | 7 |
2 | 5 |
2 | 7 |
2 | 8 |
The second represents the users to which group they belong:
IdGroup | IdUser |
5 | 1 |
5 | 2 |
5 | 3 |
6 | 4 |
6 | 5 |
6 | 6 |
7 | 7 |
7 | 8 |
7 | 9 |
8 | 10 |
8 | 11 |
8 | 12 |
What I need, is to know which users the communication was sent to.
So my table result has to be like this:
IdCommunication | IdGroup | IdUser |
1 | 5 | 1 |
1 | 5 | 2 |
1 | 5 | 3 |
1 | 6 | 4 |
1 | 6 | 5 |
1 | 6 | 6 |
1 | 7 | 7 |
1 | 7 | 8 |
1 | 7 | 9 |
2 | 5 | 1 |
2 | 5 | 2 |
2 | 5 | 3 |
2 | 7 | 7 |
2 | 7 | 8 |
2 | 7 | 9 |
2 | 8 | 10 |
2 | 8 | 11 |
2 | 8 | 12 |
It is possible to do it with PowerQuery?
Thank you very much in advance.
Luca
Solved! Go to Solution.
i think you can do merge queries in pq
pls see the attachment below
Proud to be a Super User!
i think you can do merge queries in pq
pls see the attachment below
Proud to be a Super User!
There was duplicated data in my dataset so the result was not what i aspected.
Thank you vry much for the support!
User | Count |
---|---|
86 | |
84 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |