Hi All,
I have a column A with a list of comma separated values in the PowerPivot table A. In another table B I have a column B with a list of values. Here, I was trying to search the values from column A - Table A in Column B - Table B. The output should be 1 or more values found and shown as comma separated that is Column C. Here is the sample data. I am looking for a formula in DAX. I tried search function but I was not able to achieve the output.
I appreciate your help with this. Thank you!
I have a column A with a list of comma separated values in the PowerPivot table A. In another table B I have a column B with a list of values. Here, I was trying to search the values from column A - Table A in Column B - Table B. The output should be 1 or more values found and shown as comma separated that is Column C. Here is the sample data. I am looking for a formula in DAX. I tried search function but I was not able to achieve the output.
I appreciate your help with this. Thank you!
