Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |