DAX for finding if a particular item in a column is present in a separate list or not

[AdityaG]

Col 1	Col 2	Col 3	Output
apple		banana	apple
orange		apple	ERROR
grapes	tomato	potato	tomato
banana		tomato	banana
papaya	potato		potato

Here, column 1 represents the list of items. Column 2 represents corrected list of items from Column 1 (the ones that are blank do not need any correction). Column 3 is the "separate list".

Column 4 is the output -> if column 2 has corrections listed, output should be column 2. If no corrections are there in column 2 against column 1 item then check if the item in column 1 is in column 3. If it's present then output would be the item in column 1, if not then output is ERROR.

Please help in creating the DAX for this. Thanks.

[tamerj1 · Accepted solution]

Hi @AdityaG 

Please try Calculated Column

Ouput =
IF (
ISBLANK ( 'Table'[Column2] ),
IF (
'Table'[Column1] IN VALUES ( 'Table'[Column3] ),
'Table'[Column1],
"ERROR"
),
'Table'[Column2]
)