Combine Table

danilomorganti — Thu, 23 Apr 2020 12:47:11 GMT

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

Danilo

Re: Combine Table

camargos88 — Thu, 23 Apr 2020 13:01:54 GMT

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 — Thu, 23 Apr 2020 14:02:30 GMT

Thank you very much! It's work!

Danilo