Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 leavin...
Need Help
  • Alf94's avatar
    Alf94
    3 years ago

    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,

  • olgad's avatar
    olgad
    3 years ago

    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))

olgad's avatar
olgad
Resident Rockstar
3 years ago

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))