Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Comparing values two different tables

I have two tables joined on an ID column.  Both tables have a similar field called "Practice", and I need to check if the values are the same.  I am trying to use the EXACT function, but when I choos...
Need Help
ilton's avatar
ilton
Helper I
6 years ago

Hi! Anonymous 

The EXACT function doesnt compare values from two table.

Can you give more information on your Goal.

 

You can try making a join with Power Query.

= Table.Join(Table1, "Practice", Table2, "Practice")

 

If I solved your problem please consider marking this as a solution.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

It is basically a quality control check.  TAble A is from one system, and table B is from another system.  Both tables "should" have the same practice name per ID, but they don't always.  So I need to find where they don't match so we can do a clean-up.

  • Fowmy's avatar
    Fowmy
    Super User
    6 years ago

    Anonymous 

    You can try like the following example, these two tables will show rows of one table which do not appear in another table.

    Table 1 = EXCEPT(VALUES(Employees1[FirstName]),VALUES(Employees2[FirstName]))

    Table 2 = EXCEPT(VALUES(Employees2[FirstName]),VALUES(Employees1[FirstName]))

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn