Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |