extract data from two tables - DAX Formula

[hengsworld]

I am looking for a DAX query that will simplify my current process... 

Currently, I have a table call Active Directory in Power Bi that contains the username, email, and managers etc. And I am importing a table 1 (Manager or higher)  with a list of names and connecting it to Active Directory table. All I want is to get a list of names in active directory that report up to Table 1, so manager and table 1 names are the same and username will list names that report up . Then, I manually export that data and reimported to make visualization. 

How can I utilizes DAX to automate this process and it would also be GREAT if I can go a level deeper meaning that Table 1 will have managers reporting to it and more people reporting to that managers. All in one table. 

Is this possible? 

[Phil_Seamark · Accepted solution]

Hi there,

You can do this in DAX, but it might be better to do this in the Query Editor.

If you have a common column then have a look at the Merge/Append functions inside the Query Editor.  Using these, you can create a 3rd table that is the combinations of the first two.

There might be some useful tips for you in this blog

http://radacad.com/append-vs-merge-in-power-bi-and-power-query