Forum Discussion
frankhofmans
Helper IV
Helper IVmultiple relationships
hi Pbi experts, I have three tables in power bi. Table 1: "task executed", with columns "case_id","employee_id" (the employee that executed the task),"date_executed", "task_name". Table 2: "task...
Since the two employe_id columns in the 2 different tables have a different context (executed epmployee versus responsible employee), I would import the employee table 2 times into PowerQuery(Transform area) and name one ResponsibleEmployee and the other ExecutedEmployee. Then, relate the ExecutedEmployee (by employee_id) to the "task executed" table and relate ResponsibleEmployee to the "cases" table.