Create table with unique values from 2 dimension tables

[SteveMBSDO]

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.

Dynamic Date Table:

Installation Table:

I would like my new table to have all installations per 1 day for each day in the dynamic table. It would look something like:

 

Is there an easy and smart way to do this?

Thank you for helping!

Kind regards,

Steve

[andhiii079845]

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 · Accepted solution]

Hi @SteveMBSDO 

Table =
CROSSJOIN ( 

ALLNOBLANKROW ( dimDate[Date] ),

ALLNOBLANKROW ( Installation[Installation] ) 

)

[SteveMBSDO]

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

[SteveMBSDO]

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?