DAX or Query: Compare two columns in different Tables

[Anonymous]

‎Hi @PowerBI 

I have 2 tables and want to compare two columns (one from each) in query editor or dax. I just need a yes they (the text values) match or no (text values) don't match in a new column. Secondly I need a count of all the orders that do not match to table 2.

 Table 1 (Primary Table)

Order No	Order Status
1234	Resolved
1235	Pending
1236	Open
1237	Resolved
1238	Resolved
1239	Pending

Table 2

Order No	Order Status
1234	Open
1235	Resolved
1236	Pending
1237	Resolved
1238	Resolved
1239	Open

I want a new column to be created (in either table) that shows when the Order status values in rows from each table match, as below:-

Order No	Order Status	Column 3
1234	Resolved	No Match
1235	Pending	No Match
1236	Open	Match
1237	Resolved	Match
1238	Resolved	Match
1239	Pending	No Match

Do i need to do this as a merge query or dax ?

Thanks

[Anonymous]

I have 2 tables and want to compare two columns (one from each) in query editor or dax. I just need a yes they (the text values) match or no (text values) don't match in a new column. Secondly I need a count of all the orders that do not match to table 2.

 Table 1 (Primary Table)

Order No	Order Status
1234	Resolved
1235	Pending
1236	Open
1237	Resolved
1238	Resolved
1239	Pending

Table 2

Order No	Order Status
1234	Open
1235	Resolved
1236	Pending
1237	Resolved
1238	Resolved
1239	Open

I want a new column to be created (in either table) that shows when the Order status values in rows from each table match, as below:-

Order No	Order Status	Column 3
1234	Resolved	No Match
1235	Pending	No Match
1236	Open	Match
1237	Resolved	Match
1238	Resolved	Match
1239	Pending	No Match

Do i need to do this as a merge query or dax ?

Thanks

[aj1973 · Accepted solution]

Hi @Anonymous 

here you go

Attached the file

https://drive.google.com/file/d/1hMWpl1vwwXlj8yDKT8vmXLUF7S207jUU/view?usp=sharing

[aj1973]

Hi @tulasi_pbi1988 

What do you mean by like this????

Please open a new thread and send me examples where I can look into your issue. Every model is unique and different.

Thanks

[tulasi_pbi1988]

Hi @aj1973 

Thank you for your reply.

Here is the link for a new thread.

https://community.powerbi.com/t5/Desktop/Comparing-two-tables-for-Non-Matched-and-Matched-Rows-to-sh...