kalyan209Frequent Visitor6 years agoSolvedComparing 2 columns HI, I am comparing 2 columns and displaying the required text in the new column using the specs below. IF Doc Type = Observation THEN “Audit Report without Observation” IF Doc Type = Audit...Show Moreparry2k6 years agokalyan209 you can containsrow function to find if TRN_ID exists in PARENT_ID or not Is Parent Exists = CONTAINSROW( VALUES('Table'[Parent_Id] ), 'Table'[TRN_ID] )
parry2k6 years agokalyan209 you can containsrow function to find if TRN_ID exists in PARENT_ID or not Is Parent Exists = CONTAINSROW( VALUES('Table'[Parent_Id] ), 'Table'[TRN_ID] )
parry2k6 years agokalyan209 you can containsrow function to find if TRN_ID exists in PARENT_ID or not Is Parent Exists = CONTAINSROW( VALUES('Table'[Parent_Id] ), 'Table'[TRN_ID] )
parry2kSuper User6 years agokalyan209 did you tried the formula? Put this new column in your table visual and you will find out if it is working or not.
Related contentCompare 2 TablesComparing 2 columns for matchesCompare 2 Date Columns by Time LogicCompare 2 tablesCompare 2 Columns
