Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
danilomorganti
Frequent Visitor

Combine Table

Hi everyone! I need your help about combine 2 table without same column.

I have a table 1 (Calendar table) and Table 2 (List of Product).

I would like to build a table with, for every row in table 1 complete list of row in table 2.

 

Example :

Table 1

Col 1|Col2

01/01/2020|True

02/01/2002|False

03/01/2020|False

 

Table 2

Col 1

Item_1

Tem_2

Item_3

 

Result

Table1.Col 1|Table1.Col 2|Table2.Col 1

01/01/2020|True|Item_1

01/01/2020|True|Item_2

01/01/2020|True|Item_3

02/01/2020|False|Item_1

02/01/2020|False|Item_2

02/01/2020|False|Item_3

03/01/2020|False|Item_1

03/01/2020|False|Item_2

03/01/2020|False|Item_3

 

Thanks in advance

 

BR 

 

Danilo

1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

Hi @danilomorganti ,

 

I've created this file as an example:  Download PBIX 

 

If you consider it as a solution, please mark as a solution and kudos.

Ricardo



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
camargos88
Community Champion
Community Champion

Hi @danilomorganti ,

 

I've created this file as an example:  Download PBIX 

 

If you consider it as a solution, please mark as a solution and kudos.

Ricardo



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Thank you very much! It's work!

 

BR 

 

Danilo

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors