Forum Discussion
How To Cross Reference Between Two Tables
*** Any assistance would be greatly appreciated !! *** I have two tables; Scores and Sample Table, one (Scores) containing a list of 200 names. The other table (Sample Table) is a copy of first ...
Hi cmcgo3 ,
Please try code as below to create a measure.
m1 =
IF ( MAX ( 'All DATA'[name] ) IN VALUES ( 'SAMPLE DATA'[name] ), 1, 0 )
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, will give it a try
