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

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report

Hi Martin,

Please check this link for the relationship model.

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

Was this reply helpful? Yes No
Martin Booth 40 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

Parag Chapre 12,254 Most Valuable Professional on at

Like (1)

Report

Hi Martin,

The link is cdm_leaverequestdetail > cdm_leavetypeid and cdm_typeid from cdm_leavetypereasoncode

Was this reply helpful? Yes No