Lookup table check inputs

Hello I have a table "Control de Calidad" with a form that has two inputs ([Control de Adhesivos] and [Control de Calidad]) with options (YES and NO). I want to bring the last Date and Time ([Fecha y hora]) for the last Row that checks if the "Coche" is the same of the form and ([Control de Adhesivos] OR [Control de Calidad]) has the check on YES. Iยดm trying this formula but is giving me the last ROW and not checking the OR.

 

Can someone explain me whatยดs  wrong? 


Thanks and happy holidays to everyone.

 

 

LOOKUP(
MAX(
SELECT(
Control de Calidad[_ROWNUMBER],
or(([_THISROW].[Coche] = [Coche]),
([_THISROW].[Control de Adhesivos] = "SI"),
([_THISROW].[Control de Calidad] = "SI"))
)
),
"Control de Calidad",
"_ROWNUMBER",
"Fecha y hora"
)

 

 

0 4 145
4 REPLIES 4
Top Labels in this Space