Forum Discussion
Date Table Relationships
Hi,
I have two tables, a MASTER data table which has all the data I am using within a People Dashboard, and a Calendar table.
The issue I am having is that I want both joining date and leaving date to have an active relationship to the date column in the Calendar table.
However, when I try to create this relationship, one is made active and the other is made inactive, and i cannot change this.
How can I possibly resolve this issue so that both relationships are active?
Thank you
Hello Anonymous
You can't have two active relationships in same time. The trick is to use the USERELATIONSHIP() function when you want to use the inactive relationship.
Best,
There is no way to have two active relationships between two tables.
Keep both relationships, one is active one is inactive, and then when calculating joiners, then sum(joiners), when calculating leavers then Calculate(sum(Leavers), USERELATIONSHIP(MasterTable.LeavingDate, Calendar.Date))
2 Replies
Hello Anonymous
You can't have two active relationships in same time. The trick is to use the USERELATIONSHIP() function when you want to use the inactive relationship.
Best,
There is no way to have two active relationships between two tables.
Keep both relationships, one is active one is inactive, and then when calculating joiners, then sum(joiners), when calculating leavers then Calculate(sum(Leavers), USERELATIONSHIP(MasterTable.LeavingDate, Calendar.Date))