"True" or "False" response validation column

admfabiomachado — Fri, 15 May 2020 01:06:43 GMT

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)

Re: "True" or "False" response validation column

mahoneypat — Fri, 15 May 2020 01:45:52 GMT

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

topic "True" or "False" response validation column in DAX Commands and Tips

"True" or "False" response validation column

Re: "True" or "False" response validation column