Hi Sir and Ma'am, I'm looking for a DAX to accomplish the following:I have 2 tables wherein there are identical values. I need to have table 1 to reflect which values are identical to table 2. Identical values should be marked as "Yes", if not identical it should be "No". 1. Here is an example. Below are 2 tables: 2. In Table 1, I need to identify which Container # are identical to Table 2. Create a new column to mark which container numbers are identical ("True" if identical, "False" if not identical).Do I need to creat a relationship for these 2 tables before creating a DAX? Any assistance that you can provide would be greatly appreciated. Best regards,Mark V.

markefrody Here is one way. Create a measure as follows Claimed = VAR Identical = COUNTROWS ( INTERSECT ( Table1, Table2 ) ) RETURN IF ( Identical = 1, "Yes", "No" ) Now create a table visual from table1 and add the measure. Edit: if the names of the columns are different, the you might need to use the following (which renames the columns to match them): Claimed = VAR T1 = SELECTCOLUMNS ( Table1, "ID", Table1[ID], "Date Shipped", Table1[Date shipped] ) VAR T2 = SELECTCOLUMNS ( Table2, "ID", Table2[ID], "Date Shipped", Table2[Date shipped] ) VAR identical = COUNTROWS ( INTERSECT ( T1, T2 ) ) RETURN IF ( identical = 1, "Yes", "No" )

Checking 2 Tables to Identify Identical Values

Forum Discussion

Related content

Workspace Identity

Identity Insert On Warehouse table

Identifying duplicates

Rolling Date Identifiers

Authentication to Sharepoint via Workspace Identity