Forum Discussion
Helper ICreate 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.
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
Hi SteveMBSDO
Table =
CROSSJOIN (ALLNOBLANKROW ( dimDate[Date] ),
ALLNOBLANKROW ( Installation[Installation] )
)
4 Replies
andhiii079845Solution Sage
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
Community Champion
Hi SteveMBSDO
Table =
CROSSJOIN (ALLNOBLANKROW ( dimDate[Date] ),
ALLNOBLANKROW ( Installation[Installation] )
)
SteveMBSDOGreat! 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?