Forum Discussion
Comparing Column Values (Column A vs Column B)
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
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
Thanks! The goal is to create a table showing names from source #2 that are not in source #1..
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