Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have 2 tables...
Table 1
Employee ID | Employee Name |
E001 | Jaimie |
E002 | Fred |
E003 | Isaac |
E004 | Jones |
E005 | Billy |
Table 2
Job ID | Employee ID | Line Manager Job ID | Line Manager Employee ID | Line Manager Name |
J001 | E001 | |||
J002 | E002 | J001 | E001 | |
J003 | E003 | J002 | E002 | |
J004 | E004 | J002 | E002 | |
J005 | E005 | J003 | E003 |
I was able to populate the Line manager employee ID as follows...
Solved! Go to Solution.
@Edirin Hmm, worked perfectly fine for me, see attached PBIX. Perhaps trying to do a Trim and Clean in Power Query for all of your columns to remove trailing whitespaces, etc. See attached PBIX below signature.
Hi, @Edirin ;
You could try create a column by dax.
Line Manager Name = CALCULATE(MAX('Table1'[Employee Name]),FILTER('Table1',[Employee ID]=EARLIER(Table2[Line Manager Employee ID])))
Or
Column = LOOKUPVALUE('Table1'[Employee Name],Table1[Employee ID],'Table2'[Line Manager Employee ID])
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Edirin ;
You could try create a column by dax.
Line Manager Name = CALCULATE(MAX('Table1'[Employee Name]),FILTER('Table1',[Employee ID]=EARLIER(Table2[Line Manager Employee ID])))
Or
Column = LOOKUPVALUE('Table1'[Employee Name],Table1[Employee ID],'Table2'[Line Manager Employee ID])
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Edirin Hmm, worked perfectly fine for me, see attached PBIX. Perhaps trying to do a Trim and Clean in Power Query for all of your columns to remove trailing whitespaces, etc. See attached PBIX below signature.