Forum Discussion

SteveMBSDO's avatar
SteveMBSDO
Icon for Helper I rankHelper I
3 years ago
Solved

Create table with unique values from 2 dimension tables

Hello,   I would like to create a new table from 2 dimension tables. The dimension tables are a dynamic date table and a table which contains different installations. There are 20 installations.  ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi SteveMBSDO 

    Table =
    CROSSJOIN ( 

    ALLNOBLANKROW ( dimDate[Date] ),

    ALLNOBLANKROW ( Installation[Installation] ) 

    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi SteveMBSDO 

Table =
CROSSJOIN ( 

ALLNOBLANKROW ( dimDate[Date] ),

ALLNOBLANKROW ( Installation[Installation] ) 

)

SteveMBSDO's avatar
SteveMBSDO
Icon for Helper I rankHelper I
3 years ago

Great! Wonderful, exactly what I was looking for :)! Thank you very much.