cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sokatenaj Member
Member

Relationship Conundrum Between Two Tables

Hi Folks,

 

I have one table called "Current" which has all active employees (A different employee on each row with no duplicates). I then have another table called "RSU" which is a table that grants restricted stock to our employees and the data looks like this: 

 

Account IDAward NumberPlanTypeClassAward DateGrant Date Market ValuePriceSharesAward Vest TemplateVest Base DateActiveShares 1Vest Date 1Expire Date 1Shares 2Vest Date 2Expire Date 2Shares 3Vest Date 3Expire Date 3Shares 4Vest Date 4
12345031796200ARSUser05/15/201517.10000.00104,666.004yr 25%05/15/2015Yes166.0009/30/2015 1,000.0009/30/2016 2,000.0009/30/2017 1,500.0009/30/2018
12345036568200ARSUser05/19/201616.18000.00104,250.004yr 25%05/19/2016Yes1,750.0009/30/2016 2,000.0009/30/2017 500.0009/30/2018   
678041832200ARSUser03/03/201717.17000.00107,688.00None03/03/2017Yes2,563.0009/30/2017 2,563.0009/30/2018 2,562.0009/30/2019   
60036660200ARSUser05/27/201616.59000.00105,200.00None05/27/2016Yes2,600.0005/01/2018 2,600.0005/01/2019      
611036855200ARSUser05/27/201616.59000.00102,450.003yr 33%05/01/2016Yes817.0005/01/2017 817.0005/01/2018 816.0005/01/2019   
611043753200ARSUser07/03/201717.16000.00102,388.003yr 33%07/01/2017Yes796.0007/01/2018 796.0007/01/2019 796.0007/01/2020   
89036961200ARSUser05/27/201616.59000.00103,900.003yr 33%05/01/2016Yes1,300.0005/01/2017 1,300.0005/01/2018 1,300.0005/01/2019   

 

The Account ID field is actually the employee ID. However, I cannot create a relationship between the "Current" table and the "RSU" table because it requires unique values. The RSU has duplicates such as "12345" twice because they were given RSUs two different times and I need the data in this format. 

 

The reason is that I need to calculations based on vesting date as part of a bonus roll-up and I need that data in there. 


How do I rectify this? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
fhill Established Member
Established Member

Re: Relationship Conundrum Between Two Tables

You should be able to create a 1 (Active Employee Table) to Many (RSU Table).  If you are still receiving an error, double check you don't have duplciates in the Active Employee Table.

 

FOrrest

4 REPLIES 4
amback00
Advisor

Re: Relationship Conundrum Between Two Tables

@sokatenaj - I would suggest checking out this article as it may point you in the right direction:  https://blogs.technet.microsoft.com/cansql/2016/12/19/relationships-in-power-bi-fixing-one-of-the-co...

amback00
Advisor

Re: Relationship Conundrum Between Two Tables

@sokatenaj - I would suggest checking out this article as it may point you in the right direction:  https://blogs.technet.microsoft.com/cansql/2016/12/19/relationships-in-power-bi-fixing-one-of-the-co...

Highlighted
fhill Established Member
Established Member

Re: Relationship Conundrum Between Two Tables

You should be able to create a 1 (Active Employee Table) to Many (RSU Table).  If you are still receiving an error, double check you don't have duplciates in the Active Employee Table.

 

FOrrest

sokatenaj Member
Member

Re: Relationship Conundrum Between Two Tables

Thanks All. I stupidly had a duplicate and didn't see it. #ID10TError Smiley Happy