Forum Discussion
Creating relationships / Creating a table with the same values from 2 tables.
Hi Tomas,
This kinda depends on what the cause of the issue is. If these 4 employees are actually 1 employee, the best course of action would be to delete the 3 duplicate records (preferably in the data source, but you could do this in Power query as well with the remove duplicates option) because this would be a data quality issue that could cause trouble in the future as well. If these are 4 unique employees which happen to have the same name, you would have to find a different way to formulate the employee key (for example by a employeeID if the this is available in the source). But I assume the issue is duplicates in this case, since all the doubles have the same name.
I hope that clarifies!
regards,
Tim
Hi Tomas,
This kinda depends on what the cause of the issue is. If these 4 employees are actually 1 employee, the best course of action would be to delete the 3 duplicate records (preferably in the data source, but you could do this in Power query as well with the remove duplicates option) because this would be a data quality issue that could cause trouble in the future as well. If these are 4 unique employees which happen to have the same name, you would have to find a different way to formulate the employee key (for example by a employeeID if the this is available in the source). But I assume the issue is duplicates in this case, since all the doubles have the same name.
I hope that clarifies!
regards,
Tim
Thank you!
I did check my datasource- there were duplicates that should not be there.
It will help to prevent future problems with the reports 🙂
However there is 1 employee working on 2 positions, so giving an employee ID might be neccessary.