Create new table combining data from other tables

[Juampi]

Hello ! 

I am new using power bi so i am sorry if this is a basic question. Tried to search similar questions but couldnt find an answer.

I want to create a new table (Table 3. Result) combining data from two other tables (Table 1 and 2) in the following way:

Table 1:

ID	Description
1	A
2	B
3	C

Table 2:

Attribute

XX

YY

ZZ

Table 3. Result

ID	Description	Attribute
1	A	XX
1	A	YY
1	A	ZZ
2	B	XX
2	B	YY
2	B	ZZ
3	C	XX
3	C	YY
3	C	ZZ

Thanks ! 🙂

Juampi

[amitchandak · Accepted solution]

@Juampi ,

crossjoin(Table1,Table2)

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

[Juampi]

Thanks 🙂 it worked!

[Tahreem24 · Accepted solution]

@Juampi ,

Create new table using below CrossJoin DAX:

New Table = CROSSJOIN(Tbl1,Tbl2)

Refer screen shot attached:

[amitchandak · Accepted solution]

@Juampi ,

crossjoin(Table1,Table2)

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/