Forum Discussion
Helper IIFilter for Duplicates in the same table from two different columns and relate to third column
Hello,
I have a table of Employee master with Employee id(Employees and manger IDs) , manager id and emp country . I have to filter out the manger id from the employee id and related country in a calculated column.
below screenshot will explain the situation.
How can we do that?
All suggestions are welcome
Thank you
Hi unknown_anony ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a calculated column.
Manager country = CALCULATE(MAX('Table'[Emp country]),FILTER('Table','Table'[Emp id]=EARLIER('Table'[manager id])))(3) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi unknown_anony ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a calculated column.
Manager country = CALCULATE(MAX('Table'[Emp country]),FILTER('Table','Table'[Emp id]=EARLIER('Table'[manager id])))(3) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
unknown_anonyWorked smoothly thank you so much