Tag all employee records with Active if their Staff Stage is equal to Staff

[rush]

Hi

I have an employment table with mutiple records whereby for each individual they are tagged with either Staff , Ex-staff  or Starting.

I would like to create a measure or column that will identify if an individual is tagged with Staff then the rest of his records should be tagged with Active.

Please see image below for the data that I have where I would like to replicate the last column.

Thanks.

[Zubair_Muhammad · Accepted solution]

@rush 

Try this as a column

=
IF (
    CONTAINS (
        FILTER ( TABLENAME, TableName[PersonID] = EARLIER ( TableName[PersonID] ) ),
        [Staff Stage], "Staff"
    ),
    "Active",
    "Inactive"
)

[rush]

@Zubair_Muhammad  Thanks a lot.

It is working well.

Much appreciated.