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.
Can you give an exemple of what you want to search?
This how you search for a comma. You can use it in a context like LEFT([sales person],FIND(...)-1) kind of thing.