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.
Hi Guys,
How do i create a relationship or re model my Table1 so I can link the two tables via the Date field. I keep getting the error my dates need to be unique in Table 1.
I understand why and what the problems will be. What's the best way around it. I was thinking doing a seperate table for each company, but there are 60+ companies and
what if there's a new one. How about using a key? " ID - DATE" that will make it unique, but how will I make it connect to the Master Calendar Table?.
Table 1
ID Date sales
1 01/01/2018 673673
2 01/01/2018 33883
Master Calendar
Date Month Year Day
01/01/2018 1 2018 1
02/01/2018 1 2018 2
Solved! Go to Solution.
Hi,
It should work based on your example.
Make sure the relationship is set correct. Creat the relationship manually:
In Home Tab click "Manage Relationships"
Click New...
In the Top Section Select the table with Many (Table 1)
In the secon section select the Calendar table
Cardinality: Many to One
Cross Filter direction: Single
In the visual schema you should see the connection line with a arro pointing from the Calendar to Table 1
Hi,
It should work based on your example.
Make sure the relationship is set correct. Creat the relationship manually:
In Home Tab click "Manage Relationships"
Click New...
In the Top Section Select the table with Many (Table 1)
In the secon section select the Calendar table
Cardinality: Many to One
Cross Filter direction: Single
In the visual schema you should see the connection line with a arro pointing from the Calendar to Table 1
Thank you, must familiarise myself joining tables that way.
Thanks
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |