Get names from another table

[Johny_Freitas]

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.

i tried to use ref, but it get all names

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

what can i do?

[Steve · Accepted solution]

Try:

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

[Johny_Freitas]

Steve:

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

Ty, is what i need