How to create a table based on two other tables ?

[doume06]

Hi Power Bi community,

I'm quite new to Power BI.

I want to create a table based on two other tables this way:

Source Table 1: SysID

A

B

C

D

Source Table 2: Year-Month

202001

202002

202003

202004

Target Table I want to create will contain two columns like this

SysID  Year-Month

A      202001

A      202002

A      202003

A      202004

B      202001

B      202002

B      202003

B      202004

C      202001

C      202002

C      202003

C      202004

D      202001

D      202002

D      202003

D      202004

The problem is that I have thousands of SysID and at least 24 Year-Month so I can't do it in Excel let's say...

I can't find the solution in Power BI. Can you help ?

Thanks in advance

Dominique

[amitchandak · Accepted solution]

@doume06 , Try to use crossjoin

New table = crossjoin(Table1, Table2)

[doume06]

@amitchandak 

It was fast !!!

Thanks a lot

It seems to do the job