Forum Discussion

Regular Visitor

6 years ago

Solved

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

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 fr...

parry2k
6 years ago
mmoeller try this to create new table

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

Would appreciate Kudos 🙂 if my solution helped.

Icon for Super User rank

Super User

6 years ago

mmoeller try this to create new table

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

Would appreciate Kudos 🙂 if my solution helped.