Share
ReportHi,
I'm trying to link worker to department in Power BI, but can't seem to find the right columns to create a relationship on. Has anyone one created this link before? How did you do it?
You’re offline. This is a read only version of the page.
30
Hi,
I'm trying to link worker to department in Power BI, but can't seem to find the right columns to create a relationship on. Has anyone one created this link before? How did you do it?
Great.
Can you please mark the answer as verified so that it can help others?
Hi Parag
Thanks for the help!! That worked perfectly!
Hi Martin,
Use cdm_worker for Worker then link with cdm_positionworkerassignmentmap based on cdm_workerid
After that, use cdm_jobposition to get the department of worker based on the relation with cdm_positionworkerassignmentmap on cdm_jobpositionid
You will get cdm_departmentid and you can use cdm_department to get department number and name based on cdm_departmentid
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (