If function with filter

[Anonymous]

Hi,

i have a employee column and a customer column. i want to know if an employee ever worked for company A.

If true i want to have as a result a 1 by all the companies the employee has worked

See picture below

https://www.dropbox.com/s/oakxyws0annyfs2/If%20function%20with%20filter.xlsx?dl=0

[Zubair_Muhammad · Accepted solution]

Try

=
IF (
CONTAINS (
FILTER ( table1, [emp id] = EARLIER ( [emp id] ) ),
[customer], "company A"
),
1,
0
)