Forum Discussion
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...
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.
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