Get names from another table

hi guys, i need to get some names from another column called tecnico, i need to show these names in a column, but only if column permissao is equal tecnico.
image

i tried to use ref, but it get all names


and at valid if i get this error: cannoc compare list
image

what can i do?

Try:

SELECT(
  whatever-table[Nome],
  ("technico" = [Permissao])
)
3 Likes

Ty, is what i need

1 Like