Merging two table

[Anonymous]

Hi All,

I have  two Table. How can i merge the two tables to get final out put

Table 1

Field1

A

B

C

Table 2

Field2

X

Y

Z

Final Output Table

Field1	Field2
A	X
A	Y
A	Z
B	X
B	Y
B	Z
C	X
C	Y
C	Z

[amitchandak]

@Anonymous ,

crossjoin(Table1, Table2) , all column should different name, otherwise use selectcolumns

[ToddChitt · Accepted solution]

I think there's a CROSSJOIN function in DAX.