Building a relationship where data is across multiple columns

[JakobGray]

I am trying to form a relationship between two tables. The unique value that I need to be able to filter/visualise is spread across multiple columns and is the employee name.

Basically, I have:

Table A with the employees details, name, location, etc.

Employee ID	Employee Name	Location	Manager	Branch

Table B with the person responsible for the work.

Application ID	Task 1	Task 2	Task 3	Task 4

I want to be able to build out visualisations for the tasks and who completed them, using things like branch and manager as slicers, but I cannot associate my employees table across multiple task columns... Any ideas.

[amitchandak]

@JakobGray , One of the ways is to unpivot the columns of the task and then you can filter.

https://radacad.com/pivot-and-unpivot-with-power-bi

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.