topic Re: Create table from unrelated columns in DAX Commands and Tips

Create table from unrelated columns

Bamse — Thu, 10 Mar 2022 14:44:06 GMT

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 () )
)

Re: Create table from unrelated columns

PaulOlding — Thu, 10 Mar 2022 14:54:24 GMT

Hi Bamse

Something like this should do it

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

Re: Create table from unrelated columns

Whitewater100 — Thu, 10 Mar 2022 15:03:25 GMT

Hi:

To start you could use CROSSJOIN

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

Re: Create table from unrelated columns

Whitewater100 — Thu, 10 Mar 2022 15:04:53 GMT

Sorry Paul, I didn't see your reply!