Hello! I have run a search which results in displaying a table. In this table, I would like to check if a combination of values between two fields exists, and, if so, return "Yes." I have done this in PowerBI using the following command, but I am unsure how to do it in SPL. VAR _SEL = SELECTCOLUMNS('table1', "code1", [code1]) RETURN IF ('table1'[code2] IN _SEL, "Yes", "No") An example initial table is below: id, code1, code2 1, ab, cd 2, cd, de 3, ab, hi 4, cd, ab 5, jk, cd 6, hi, jk 7, jk, hi The result I am looking for is that it will find that the combination of ab+cd and hi+jk exists in both directions (code1, code2 and code2, code1). id, code1, code2, result 1, ab, cd, yes 2, cd, de, no 3, ab, hi, no 4, cd, ab, yes 5, jk, cd, no 6, hi, jk, yes 7, jk, hi, yes Thank you for your help!
... View more