Combining the data from 2 columns from 2 different tables to multiply records.

[boj227]

 Hello all,

I need to create a table in Power BI that is a combination of 2 columns from 2 different tables, but it’s not really merge or append.

Table 1:

Emloyee ID	Employee Name
1	John Smoth
2	Maria Fernandez
3	Luca Still
4	Mateo Gill
5	Lucy Rensing
6	Sarah Li

Table 2:

Training ID	Traiining Name
1	Project Management Basis
2	Quoting in QuoteBuilder
3	Excel Basics

I should create something like this:

Index	Employee Name	Training Name
1	John Smoth	Project Management Basis
2	Maria Fernandez	Project Management Basis
3	Luca Still	Project Management Basis
4	Mateo Gill	Project Management Basis
5	Lucy Rensing	Project Management Basis
6	Sarah Li	Project Management Basis
7	John Smoth	Quoting in QuoteBuilder
8	Maria Fernandez	Quoting in QuoteBuilder
9	Luca Still	Quoting in QuoteBuilder
10	Mateo Gill	Quoting in QuoteBuilder
11	Lucy Rensing	Quoting in QuoteBuilder
12	Sarah Li	Quoting in QuoteBuilder
13	John Smoth	Excel Basics
14	Maria Fernandez	Excel Basics
15	Luca Still	Excel Basics
16	Mateo Gill	Excel Basics
17	Lucy Rensing	Excel Basics
18	Sarah Li	Excel Basics

Is there any way to do this in Power Query?

Thanks in advance for help. 

[boj227]

Yes, this is it! Thank you so much!

[serpiva64 · Accepted solution]

Hi,

you can find the solution in this article

https://learn.microsoft.com/en-us/power-query/cross-join

Look also a the attached file (there is also the crossjoin in Dax)

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!