Matching two columns from two tables

[Anonymous]

Hello, everybody.

Could you help me this issue.

I have 2 tables data like picture. I want to show only the rows contians table A[beam] = table B[beam] and table A[Dyeing batch] = table A [Dyeing batch].

Thank you so much!!!

[Anonymous]

Hi @v-yueyunzh-msft ,

Could you help me with this further?
Do you know why when adding the yards length column, the results is not correct?

Thank you so much!!!

[Anonymous]

Wow... thank you so much. That's a perfect solution.

[v-yueyunzh-msft · Accepted solution]

Hi , @Anonymous 

According to your description, you want to show the special rows when two columns is the same . For your need , you can realize it in Power Query Editor.

You can click "Merge Queries as New" in Power Query Editor:

Then we can get this table , you can also determine if you need to expand the table :

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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