Combining two tables

[LucaUSA50]

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

[quentin_vigne · Accepted solution]

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

[LucaUSA50]

It works!!

Thanks

[quentin_vigne]

@LucaUSA50

You're welcome

have a good day

- Quentin