Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
Thank you very much! It's work!
BR
Danilo