Using a join on a calculated column

[jak8282]

Hi,

I am creating a merge calculated column using lookupvalue to pull the manager name out of another table.

Am I able to then join that merged calculated column to another table.  The join doesnt seem to work and userelationships is njot bringing back any data?

Thanks

Chris

[amitchandak]

@jak8282 , Hope you are using userelationship in meausre and join is inactive ?

Join is inactive because of mutiple join, not because some loop or relationship error

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

For Userelationship

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...