Forum Discussion

LucaUSA50's avatar
LucaUSA50
Frequent Visitor
8 years ago
Solved

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

  • 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