Power BI: Dax: New column: If criteria occurs more than once return "1" with the last occurence

[govi]

Hi all,
I have this table:

I want to create a column "excludedUser" in which to return "1" when the column "status" says "ExcludedFromProject"

But sometimes a user is accidentally excluded, and later included ("IncludedInProject") again.

In the example above (rows in yellow) the first "ExcludedFromProject" for user 14195 must not return "1" in column "excludedUser" because is later the user is included again.

On 9-1-2019 the user is excluded for real, and then "1" should be returned.

Could someone help me?

Thanks!
govi

 

[govi]

I already have a solution:

Column 2 =
VAR x =
CALCULATE(
    MAX(Sheet1[timestamp]),
    FILTER(
        ALL(Sheet1),
        Sheet1[userId] = EARLIER(Sheet1[userId]) && Sheet1[status] = "EFP"
    )
)
VAR y =
CALCULATE(
    MIN(Sheet1[timestamp]),
        FILTER(
            ALL(Sheet1),
            Sheet1[userId] = EARLIER(Sheet1[userId]) && Sheet1[status] = "EFP"
        )
)
VAR z =
SWITCH(
    TRUE(),
    Sheet1[timestamp] = x && Sheet1[status] = "EFP", "1",
    Sheet1[timestamp] >= y && Sheet1[timestamp] <= x &&Sheet1[status] = "EFP", "no value",
    BLANK()
)
RETURN
z

z