How to link cdm_leaverequestdetail to cdm_leavetypereasoncode

(0) Share

Report

Posted on by Martin Booth

I'm trying to create a power bi report that shows leave request details but filtered on the leave reason code, but I'm struggling to link the two tables together.

Can you please help

All responses (3)

Answers (1)

Verified answer

Parag Chapre 12,248 Most Valuable Professional on at

Like (1)

Report

RE: How to link cdm_leaverequestdetail to cdm_leavetypereasoncode

Hi Martin,

The link is cdm_leaverequestdetail > cdm_leavetypeid and cdm_typeid from cdm_leavetypereasoncode
Martin Booth 30 on at

Like (0)

Report

RE: How to link cdm_leaverequestdetail to cdm_leavetypereasoncode

Hi Parag

Thanks for the diagram. I still can see how to link the two specific tables together from the diagram, have I missed something?
Suggested answer

Parag Chapre 12,248 Most Valuable Professional on at

Like (0)

Report

RE: How to link cdm_leaverequestdetail to cdm_leavetypereasoncode

Hi Martin,

Please check this link for the relationship model.

docs.microsoft.com/.../hr-developer-entities