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.

  • 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.

  • 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?