Inactive relationships

[Anonymous]

Hi everyone,

I have two tables. One is user, one is approval process.
In the approval, there are requesters and approvers.
I want to connect these two tables so one of them will be inactive.

What I want to do is viewing the visual by the specific requester, another visual by approver like below in BI.

For example, I want to get the record of user A.

Approver	Subject	Requester
A	….	B
A	…	C
A	…	D

Approver	Subject	Requester
X	…	A
Y	…	A

How can I do this?

Thanks!

[amitchandak · Accepted solution]

@Anonymous , expected output is not clear. refer these examples

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