Table links for worker and department

(0) Share

Report

Posted on by Martin Booth

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?

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Parag Chapre 12,254 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Martin Booth 40 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Parag

Thanks for the help!! That worked perfectly!

Was this reply helpful? Yes No
Verified answer

Parag Chapre 12,254 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Great.

Can you please mark the answer as verified so that it can help others?

Was this reply helpful? Yes No