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

    )

andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

You need a date column in your installations table in the correct format (Date) and create a relationsship between both tables. Than you are able to create a matrix with the date column from the DIMTable and the installation column.

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

Thank you for your reply. I'm a bit confused. Do you want me to just add 1 column in the table with just 1 date for the 20 installations? How can I then make a Matrix?