All Distinct Values from Table1 Column1 for Each of All Distinct Values from Table2 Column2

[mmoeller]

Hi,

I have two columns in two different tables, and I want to make a new table with DAX that lists each of ALL distinct values from a column in the first table with each of ALL Distinct Values from a column in the second table.  As a note, these two tables are not related in any way.

Table 1		Table 2		Resultant Table
Column 1		Column 2		Column 3	Column 4
1		A		1	A
2		B		1	B
2		B		2	A
3		B		2	B
				3	A
				3	B

Thanks,

Mo

[parry2k · Accepted solution]

@mmoeller try this to create new table

New Table = 
CROSSJOIN (
VALUES ( Table1[Column1] ),
VALUES ( Table2[Column2] )
)

Would appreciate Kudos 🙂 if my solution helped.