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
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
Thank you David & Frank! Both solutions worked!
I appreciate your help!