Dear Team, I have following Tables. Operator Directory - Emp Id, Operator Name, Status Operator Certification - Model Type, Certification Type Equipment Directory - Eq Code, Model Type Now If i select Eq Code with particular Model Type, Certification Type and Status, i should get list of Emp id, that will match Model Type, Certification type and Status. Can i use this formula?
ANY(SELECT(Operator Directory[Short Name], IN(Select(Operator Certification[Emp Id], AND([Certification Type] =[_THISROW].[Certification Type], [Model Type]=[_THISROW].[Model Type],
[Business Unit] = [_THISROW].[Business Unit]))))