"True" or "False" response validation column

[admfabiomachado]

Any solution in Excel or Power BI that can insert a "True" or "False" response validation column after comparing data from table 1 with rows in table 2 (agent_id column), the only one using the data in table 1 is within the data range of table 2 (data table 1> = start_data and <= end_date)

[mahoneypat]

Try this expression in your calculated column

Valid = var startdate = LOOKUPVALUE(Tabela_2[data_inicio]), Tabela_2[id_agente], Tabela_1[id_agente])

var enddate = LOOKUPVALUE(Tabela_2[data_fim]), Tabela_2[id_agente], Tabela_1[id_agente])

return if(and(Tabela_1[data]<= enddate, Tabela_1[data]>=startdate), "True", "False")

If this solution works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat