title: DAX IF statement to compare numbers in separate tables?
body: <p>I'm having some trouble in Power BI when trying to find a specific number. I've got two tables, Table 1 and Table 2. In Table 1 I have two columns, "Consignment number" and "Subcontractor". In Table 2 I have a column "Consignment ID". Columns "Consignment number" and "Consignment ID" have a few numbers that overlap.</p>
  
  <p>I need to find a way to create a calculated column in Table 1 that identifies these overlaps in the easiest way. I've been exploring using IF statements with USERELATIONSHIP statements, but I'm not sure how to make it work. </p>
  
  <p>Would greatly appreciate any suggestions that you might have. Thank you! </p>