Forum Discussion
Get Manager ID from Employee Full Name vs. Incomplete Manager Name
Hi guys, I still bang my head towards this. I have a CSV that is like this: EmployeeID / EmployeeName / ManagerName 1 / John Kenneth von Lichtenstein / Barbara Streisand 2 / Cruela Ba...
Hi UncleCaesar ,
You need to create a calculated column instead of a measure, which is probably why you're getting it wrong. Refer to below pbix file.
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, looking closely it doesn't work for you either, cause Barbara Streisand has Manager ID "2" instead of "3" and John Kenneth appears correct only on the 2nd row, on the 3rd one it's blank.