Forum Discussion

JorgeLuizMS's avatar
JorgeLuizMS
Regular Visitor
5 years ago
Solved

Create a Calculated column with a partial match.

Hi people!   I have the following situation, would anyone be able to give me some help.   I have two tables: D_CLIENTS = table with the registration of customers. F_CALLS = table that records t...
  • wdx223_Daniel's avatar
    5 years ago

    =MAXX(FILTER(D_CLIENTS,FIND(F_CALLS[CALL NUMBER],D_CLIENTS[TELEFONE],,0)),D_CLIENTS[NOME])