How to create a table based on two other tables ?

Question

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: SysIDABCDSource Table 2: Year-Month202001202002202003202004&nbsp;Target Table I want to create will contain two columns like thisSysID&nbsp; Year-MonthA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202001A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202002A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202003A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202004B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202001B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202002B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202003B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202004C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202001C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202002C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202003C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202004D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202001D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202002D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202003D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202004&nbsp;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 advanceDominique&nbsp;

amitchandak · Accepted Answer

doume06 , Try to use crossjoin
&nbsp;
New table = crossjoin(Table1, Table2)

Forum Discussion

How to create a table based on two other tables ?

2 Replies

Related content

Lakehouse Table Generate Create Table

Create new table

Create rows from 2 tables

Creating Date Tables

Matrix table