Combine Table

[danilomorganti]

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

[camargos88 · Accepted solution]

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

[danilomorganti]

Thank you very much! It's work!

BR 

Danilo