Forum Discussion

Bamse's avatar
Bamse
Frequent Visitor
4 years ago
Solved

Create table from unrelated columns

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

  • PaulOlding's avatar
    PaulOlding
    4 years ago

    Hi Bamse 

    Something like this should do it

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

3 Replies

  • PaulOlding's avatar
    PaulOlding
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi Bamse 

    Something like this should do it

    CROSSJOIN (
            VALUES ( 'Dates'[Date] ),
            VALUES ( 'Cars'[Brand] )
        )
  • Whitewater100's avatar
    Whitewater100
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi:

    To start you could use CROSSJOIN

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