Table1 is name database, Table2 is name entry. As Mark is not in the data base, I want to has a measure that could capture the mismatch of these two colunms in two tables. Thanks
1 ACCEPTED SOLUTION
@Anonymous Try:
CONCATENATEX( EXCEPT('Table1', 'Table2', [Name], ",")Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
@Anonymous Try:
CONCATENATEX( EXCEPT('Table1', 'Table2', [Name], ",")Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
