Merge queries

[lucadelicio]

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

[ryan_mayu · Accepted solution]

@lucadelicio 

i think you can do merge queries in pq

pls see the attachment below

[lucadelicio]

There was duplicated data in my dataset so the result was not what i aspected.

Thank you vry much for the support!