Forum Discussion
Find the value based on Comma seperated list
Hi Anonymous
For table1 , you could split the delimitted collumn into more/other columns.
Go to edit query >> Right click the column >> Split Column (By Delimiter)
This will create a table with 3 columns. A,B,C --> A | B | C
Create another custom column to concatenate all values that are not reported to.
A | B | C --> A | B | C | A, B
Split:
Result:
In table2 you can create a look up to match the reporting to values and retreive the concatenated column.
Not sure what you need with the amount.
Cheers!
A
I believe you need to create a bridging_table to link table A to B.
It will involve the split solution proposed by Anonymous . but would be better off creating it in a referenced table and pivoting the result to link to use it as a link.
Something like this:
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!
ACan 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.
