Forum Discussion
Solved
Lookup using multiple numbers that are separated by special character
Hi all, Is there a way I can lookup multiple values that are separated by ";" and return the values and have them be separated by ";". I want to use 'Table 2' to return the values in the 'Na...
Hi emily324,
You can try to use following measure formula to get the correspond name list based on current number string:
formula = VAR currNumber = SELECTEDVALUE ( Table1[Numbers] ) RETURN CONCATENATEX ( CALCULATETABLE ( VALUES ( Table2[Names] ), FILTER ( ALLSELECTED ( Table2 ), SEARCH ( Table2[Numbers], currNumber, 1, -1 ) > 0 ) ), Table2[Names], "," )Regards,
Xiaoxin Sheng
Hi emily324,
You can try to use following measure formula to get the correspond name list based on current number string:
formula =
VAR currNumber =
SELECTEDVALUE ( Table1[Numbers] )
RETURN
CONCATENATEX (
CALCULATETABLE (
VALUES ( Table2[Names] ),
FILTER (
ALLSELECTED ( Table2 ),
SEARCH ( Table2[Numbers], currNumber, 1, -1 ) > 0
)
),
Table2[Names],
","
)
Regards,
Xiaoxin Sheng
