Forum Discussion
Find the value based on Comma seperated list
I have a Table - 1 with a path (comma seperated value) of everyone who reports to someone Table 1 Column1 - value A,B,C example : A,B,C where A and B reports to C Another Table , Table 2 which ...
That might not work in my case.
Is there a DAX I could use to find/Search the column .. Since the value in column 1 will always be as one of the values in the comma seperated value.
Hey Anonymous
As I understand, the value to search will always be in the last column.
A,B,C so you want to find 'C'
C,D so you want to find 'D'
D so there is no one to find, as D is not reporting to anyone.
Bottom line,
The way the values are ordered, is the key to finding the values later on.
Cheers!
A