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