Forum Discussion

ambient_88's avatar
ambient_88
Frequent Visitor
8 years ago

Parent-Child relationship problem

Hello Guys,   I have a problem I've been trying to tackle but to no avail.   Problem: An employee can be transferred to a different supervisor in the middle of the month.   5/1 - 5/15    ...
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Please share the exact date format in that case.  Infact, share the link from where i can download your Excel file and show the expected result there in a Table format.

ambient_88's avatar
ambient_88
Frequent Visitor
8 years ago

Hello,

 

Here's the link for the sample data. 

 

https://drive.google.com/open?id=1w9h1X_irjQJAlCNJyDvDgLqO9zcZGZwn

 

As you can see, a person can be moved to a different supervisor within the month. With the way I have it set up right now, if a person moves to another team within the month, his/her score will transfer as well. We don't want that. The score under Supervisor A should stay under that supervisor.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I would appreciate if you can guide me as to how to design the data model for this. Right now I have two lookup tables (Employee and Date) and one data table (survey data).

 

Thank you.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Please refer to my solution in this PBI file.

     

    Hope this helps.