filtering data from unrelated table

[BethNurse]

I have three tables

The first table contains projects number and project-specific information

The second table contains a list of time entries with a project number field along with employee number and employee-related entry

The third table contains a list of milestones again with a project number field and information related to the milestone.

Both the second and third tables and related to the first table in a one to many single relations with the project number of the first table.

How can I transfer the filter using a field from the second table to the third table?

I would like to have a page where I could dynamically filter the project information, sum the hours and show the related milestones status bases on a slicer using an employee-related field in the second table.

Thanks

[amitchandak]

@BethNurse , You create a new column using lookup, sumx/maxx etc

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8