Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sokatenaj
Helper III
Helper III

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
fhill
Resident Rockstar
Resident Rockstar

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




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




View solution in original post

4 REPLIES 4
fhill
Resident Rockstar
Resident Rockstar

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




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




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

amback00
New Member

@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
New Member

@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...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.