Forum Discussion
Lookup to return multiple values
Hey Guys, I have two tables, Table One which has the list of countries and the other Table 2 has the countriesid amongst other fields. But within Table 2 the countriesid field, there are multiple ids...
iKettle Use CONCATENATEX(FILTER(...), ..., ", ")
I have tried this
Countries = CONCATENATEX(Filter(MasterCountryHRControlsFocals, MasterCountryHRControlsFocals[Id] = 'Audit Tracker List (2)'[CountriesId]), MasterCountryHRControlsFocals[Title], [Title], ",")
But it still only gives me one value. In the lookup, I have extracted the value in the field 'Audit Tracker List (2)'[CountriesId], so it has 234, 250, 190 etc....But using the above formula I only get the first country name and not the rest.