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

Question

&nbsp;&nbsp;Hello all,&nbsp;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.&nbsp;Table 1:&nbsp;Emloyee IDEmployee Name1John Smoth2Maria Fernandez3Luca Still4Mateo Gill5Lucy Rensing6Sarah Li&nbsp;Table 2:&nbsp;Training IDTraiining Name1Project Management Basis2Quoting in QuoteBuilder3Excel Basics&nbsp;I should create something like this:&nbsp;IndexEmployee NameTraining Name1John SmothProject Management Basis2Maria FernandezProject Management Basis3Luca StillProject Management Basis4Mateo GillProject Management Basis5Lucy RensingProject Management Basis6Sarah LiProject Management Basis7John SmothQuoting in QuoteBuilder8Maria FernandezQuoting in QuoteBuilder9Luca StillQuoting in QuoteBuilder10Mateo GillQuoting in QuoteBuilder11Lucy RensingQuoting in QuoteBuilder12Sarah LiQuoting in QuoteBuilder13John SmothExcel Basics14Maria FernandezExcel Basics15Luca StillExcel Basics16Mateo GillExcel Basics17Lucy RensingExcel Basics18Sarah LiExcel Basics&nbsp;Is there any way to do this in Power Query?&nbsp;Thanks in advance for help.&nbsp;

serpiva64 · Accepted Answer

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!

Forum Discussion

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

2 Replies

Related content

Tables combine

Combining Data from Different Semantic Models

Multiply values in columns (Different tables)

Combining files from sharepoint with slightly different layouts

Combine files with different column structure

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

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

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