New table from non related Table1.ColumnA and Table2.ColumnB, outer join

[RB1]

Hi,

Hope the title makes sense. I have two tables that are not directly related (listed below) and I need to create a third where each value from each table is captured. Example below.

Because most of the data is calculated, I cannot use the Query Editor as these tables / columns are not visible.

Table1 (Manually entered query) = "Name" and a few calculated columns

Table2 (Calculated columns only) = Month Names, Year+Month, Quarter, Year+Quarter from 2017-2019

New table needs to look like this:

A - 2017 Q1

A - 2017 Q2

A - 2017 Q3

A - 2017 Q4

A - 2018 Q....

B - 2017 Q1

B - 2017 Q2

B - 2017 Q....

Any ideas?

[v-jiascu-msft]

Hi @RB1,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[v-jiascu-msft]

Hi @RB1

You can use the function CROSSJOIN. Please also check out the demo in the attachment.

Table = CROSSJOIN('Table1', 'Table2')

Best Regards,
Dale

[Anonymous]

Hello @RB1,

You can use the DAX function USERELATIONSHIP nested with a CALCULATE, like:

CALCULATE ( [Measure] ; USERELATIONSHIP ( FirstTable ; Second Table))

Cheers,