Forum Discussion
Comparing Column Values (Column A vs Column B)
Hi there!
I've data coming from two different spreadsheets into my report that has employee names column. How can I compare employee names from source #1 to names in source#2 and generate a list of unique names in source #2? Source #2 has the accurate list of names.
Any help would be appreciated! Thanks!
Hi Anonymous,
I made one sampe using the formula as dedelman_clng provided.
MissingEmpName = CALCULATETABLE( EXCEPT( Values('Source#2'[EmpName]), Values('Source#1'[EmpName]) ) )For more details, please check the pbix as attached.
Regards,
Frank
Hi Anonymous,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
6 Replies
If Source#2 has the accurate list of names, what values do you want from Source#1 ? There are UNION, INTERSECTION and DISTINCT functions, but it depends on what you're really look for. A small example set of data would be helpful.
David
In DAX, create a new table with the following code
MissingEmpName =
CALCULATETABLE( EXCEPT(
Values(Source#2[EmpName]), Values(Source#1[EmpName])
)
)This should give you a table with a single column of names in Source#2 that are not in Source #1.
Hope this helps,
David
Hi Anonymous,
I made one sampe using the formula as dedelman_clng provided.
MissingEmpName = CALCULATETABLE( EXCEPT( Values('Source#2'[EmpName]), Values('Source#1'[EmpName]) ) )For more details, please check the pbix as attached.
Regards,
Frank
Hi Anonymous,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
