Can you dereference an EnumList base type Reference?

[sorin_mihai]

Hello,

Can you dereference an EnumList base type Reference Column?
I did try it and it doesn’t work, but I’m asking in case there is some button I haven’t seen or something…I can also live without it but if there is a workaround to make that possible it would be great.

Also, I see you cannot check the IsPartOf if the Ref is an EnumList…I wonder why?

Thank you,
Sorin

[Steve · Accepted solution]

sorin_mihai:

Can you dereference an EnumList base type Reference Column?

Nope. But you can use the list item as input to LOOKUP(). E.g., LOOKOP(INDEX([_THISROW].[EnumListCol], 4), "MyTable", "MyLookupCol", "MyResultCol").

[MultiTech]

You can also list everything associated as well:

Select(MyTable[MyResultCol], in([MyLookupCol], [_thisrow].[EnumListCol]))

[sorin_mihai]

Perfetc, good to know.

Thank you