Forum Discussion

rjtedge's avatar
rjtedge
Frequent Visitor
5 years ago
Solved

One columnn to two column relationship

Hi. I have two tables. The first is just a list of names. The second had multiple columns with project information. Each project has a unique idb and then two columns for primary and secondary contac...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, rjtedge , when you reshape your second table like this, all issues are gone with the wind. It's only a matter of clicks in Power Query.

    You may want to refer to the attached file for details.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

rjtedge , I am getting your calculation.

 

But Assuming the first one is the master table. Join it with both Primary and secondary. One join will be active and another one will be inactive. use userelation to select the join in a measure

 

refer

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

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970