Forum Discussion

Pintobean80's avatar
Pintobean80
Regular Visitor
2 years ago
Solved

Merging columns from two tables onto a third table based on criteria

I'm having a bit of trouble working all this out in my head. I have two tables that I'm bringing into Power BI (active link with both data sources). So here's basically what I'm trying to figure out ...
Need Help
  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    2 years ago

    Hi Pintobean80 ，

    As the method provided by PijushRoy  says, you can use the Merge query method.
    You may also consider using dax to solve the problem，please refer to the following content.

    My Sample:

    Table A:

    Table B:

    Based on your description, Please try code as below to create Calculated Table.

    Table3 = NATURALINNERJOIN(NATURALINNERJOIN('Table1',VALUES('Table2'[Job Title])),VALUES('Table2'[Age]))

    Result is as below.

     

    Best Regards,
    Yulia Yan

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-weiyan1-msft's avatar
v-weiyan1-msft
Community Support
2 years ago

Hi Pintobean80 ，

As the method provided by PijushRoy  says, you can use the Merge query method.
You may also consider using dax to solve the problem，please refer to the following content.

My Sample:

Table A:

Table B:

Based on your description, Please try code as below to create Calculated Table.

Table3 = NATURALINNERJOIN(NATURALINNERJOIN('Table1',VALUES('Table2'[Job Title])),VALUES('Table2'[Age]))

Result is as below.

 

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.