Forum Discussion
Combining two tables
Hello,
I have two tables: one containing dates and the other one containing product categories:
Table 1:
Table 1:
Date:
01/01/2016
01/02/2016
01/03/2016
etc.
Table 2:
Categories:
A
B
C
etc.
I need to create with power query a third table (2 columns) with: first column date and second categories and for every date it needs to have all the categories:
Table 3:
Date: Categories
01/01/2016 A
01/01/2016 A
01/01/2016 A
01/02/2016 B
01/02/2016 B
01/02/2016 B
01/03/2016 C
01/03/2016 C
01/03/2016 C
Is there a way to achieve this result?
Many thanks
Hi LucaUSA50
You simply have to go to Modelisation > New table and fill it with this formula :
NewTable = CROSSJOIN(Table1;Table2)
If it worked, don't forget to mark the topic as solved
- Quentin
3 Replies
- quentin_vigneSolution Sage
Hi LucaUSA50
You simply have to go to Modelisation > New table and fill it with this formula :
NewTable = CROSSJOIN(Table1;Table2)
If it worked, don't forget to mark the topic as solved
- Quentin- LucaUSA50Frequent Visitor
It works!!
Thanks
- quentin_vigneSolution Sage