Create New Table from columns of different sizes

[SandyBL]

I want to create a new table in powerbi that joins two columns from different tables and creates combination of all records from each column.  Thanks for the help!

Table 1:

Months

January 2017

February 2017

March 2017

Table 2:

Accounts

1

2

3

New Table

Month                 Account

January 2017       1

February 2017     1

March 2017         1 

January 2017       2

February 2017     2

March 2017         2

January 2017       3

February 2017     3

March 2017         3 

[Vvelarde]

@SandyBL

Hi, Use this (Modeling-New Table)

Table 2 = CROSSJOIN(Months,Accounts)

[SandyBL]

Thanks.  How would I choose the specific columns in each table?

[Vvelarde · Accepted solution]

@SandyBL

A sample could be:

Mytable=Crossjoin(Values(Table1[ColumnA]), Values(Table2[ColumnZ]))