Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @SteveMBSDO
Table =
CROSSJOIN (
ALLNOBLANKROW ( dimDate[Date] ),
ALLNOBLANKROW ( Installation[Installation] )
)
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.
Proud to be a Super User!
Hi @SteveMBSDO
Table =
CROSSJOIN (
ALLNOBLANKROW ( dimDate[Date] ),
ALLNOBLANKROW ( Installation[Installation] )
)
Great! Wonderful, exactly what I was looking for :)! Thank you very much.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |