Can ship date and move date link to master cal date ?

[Paulyeo11]

Hi All

Do i need bridge table to link ?

[amitchandak]

@Paulyeo11 , No that is needed for Many to Many.  In this case use userelation to activate join

refer: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Video : https://www.youtube.com/watch?v=e6Y-l_JtCq4

[manikumar34 · Accepted solution]

@Paulyeo11 , 

I can see you are creating two relationships betwwen two tables. In this case only one can act and the other will be inactivated. 

To make this work, you can create brigde table else you can use USERELATIOSHIP function to calculate on the inactive relationship and make it virtually active in the DAX. 

Refre the below link. 

https://www.sqlbi.com/articles/userelationship-in-calculated-columns/

Regards, 

Manikumar

[Paulyeo11]

Hi All

Thank you for the link