Using calculated tables to combine two unrelated columns from two different tables

[jschubert]

Hi All,

First time posting here. I am looking for some help with the following issue if it is possible.

I am hoping to merge two columns from two unrelated tables so that there would be 1 row for each combination of records, essentially repeating column 1 for each distinct record from column 2. I have attempted many different DAX functions but always run into errors, usually "A table of multiple values was supplied where a single value was expected."

Here is an example of what I am trying to acheive.

Thanks a lot!

[parry2k · Accepted solution]

@jschubert go to model tab and click "new table" and enter following expression:

Table Combine = CROSSJOIN ( Table1, Table2 )

Table combine will have expected result.

[jschubert]

Both methods worked for what I was trying. Thanks a lot!

[v-cherch-msft · Accepted solution]

Hi @jschubert 

You may also use GENERATE Function.

Table 3 = GENERATE('Table 1','Table 2')

Regards,

[parry2k · Accepted solution]

@jschubert go to model tab and click "new table" and enter following expression:

Table Combine = CROSSJOIN ( Table1, Table2 )

Table combine will have expected result.