Listing data from multiple tables in the "enumlist" column

Listing data from multiple tables in the “enumlist” column is done?

for example

SELECT(Table 1[Name], [Location]=[_THISROW].[Location]) =>> result: (A, B, C)

SELECT(Table 2[Name], [Location]=[_THISROW].[Location]) =>> result: (X, Y, Z)

SELECT(Table 3[Name], [Location]=[_THISROW].[Location]) =>> result:(U, V, W)

Valid_if how should I use a formula, to get the following result?

Enumlist (A, B, C, X, Y, Z,U, V, W)

One way is if you write the formula like…

SELECT(Table 1[Name], [Location]=[_THISROW].[Location]) +
SELECT(Table 2[Name], [Location]=[_THISROW].[Location]) +
SELECT(Table 3[Name], [Location]=[_THISROW].[Location])

3 Likes

thanks @Aleksi, I will try and return.

You’re welcome