Create table from unrelated columns

[Bamse]

Hi!

I would like to create a table containing all possible combinations of two unrelated columns from unrelated tables.
So I would like to do something like this, which obviously does not work in it's current form.

SUMMARIZE('Dates', 'Dates'[Date], 'Cars'[Brand])

Intention is to create results for every possible combination like for example:

AVERAGEX (
   <Table unrelated columns>,
   DIVIDE ( [Some Measure], __SomeVariable, BLANK () )
)

[Whitewater100]

Hi:

To start you could use CROSSJOIN

CROSSJOIN(VALUES(Dates[Date]), 
VALUES(Cars[Brand])
)

[PaulOlding · Accepted solution]

Hi @Bamse 

Something like this should do it

CROSSJOIN (
            VALUES ( 'Dates'[Date] ),
            VALUES ( 'Cars'[Brand] )
        )

[Whitewater100]

Sorry Paul, I didn't see your reply!