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...
  • PaulOlding's avatar
    PaulOlding
    4 years ago

    Hi Bamse 

    Something like this should do it

    CROSSJOIN (
            VALUES ( 'Dates'[Date] ),
            VALUES ( 'Cars'[Brand] )
        )
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

Sorry Paul, I didn't see your reply!