Forum Discussion

hengsworld's avatar
hengsworld
Frequent Visitor
9 years ago
Solved

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 im...
Need Help
Show and Tell
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    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

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

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