Forum Discussion
Look Up Comma Delimited Values in a Cell
Do you want the output to be a calculated column or a measure?
Also have you tried Fuzzy Merge in the Query editor?Assuming you split the Reviewer onto seperate rows then joined to the userid:
Cross filter lets the Many side of the join filter the 1 side.
So for each Item show the matching users.
For the same outcome but using a calculated column without unpivoting:
Apply a filter to the contacts table and test if the current row is within the current reviewer column.
Super UserDo you want the output to be a calculated column or a measure?
Also have you tried Fuzzy Merge in the Query editor?
Assuming you split the Reviewer onto seperate rows then joined to the userid:
Cross filter lets the Many side of the join filter the 1 side.
So for each Item show the matching users.
For the same outcome but using a calculated column without unpivoting:
Apply a filter to the contacts table and test if the current row is within the current reviewer column.
The calculated column in the second part is EXACTLY what I was looking for. There might be several columns on a given table that have delimited user IDs so being able to do this on a per column basis without unpivoting is insanely helpful. THANK YOU!