Solved: Lookup using multiple criteria - Page 2

Kyle_Richardson · 05-03-2019 04:01 AM

My current formula:

LOOKUP( [Date] , “Molding Manpower” , Production Date , Total People)

It returns the total people working in a workcell on a given date from my Molding Manpower table.

The problem is I have multiple shifts and operations. I need to match the “Date”, “Shift”, and “Mixer Number” and return the Total People.

I feel like in excel I would use filter() or multiple nested if() statements.

Kyle_Richardson

Solution:

ANY(
SELECT(
Molding Manpower[Total People],
AND(
([Production Date] = [_ThisRow].[Date]),
([Shift] = [_ThisRow].[Shift]),
([Mixer Number] = [_ThisRow].[Mixer Number])),
FALSE
)
)

[Hours on Job]

Thanks for pointing me in the right direction guys!

View solution in original post