Forum Discussion
extract data from two tables - DAX Formula
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?
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
1 Reply
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