get maximum date from row category

[Shruthi96]

Hi Folks, 

I am looking for a solution to categorize the row as 1 or 0 in column scope, based on maximum end date and Include column  "Yes" . Below is the snap shot i have attached.  Can you help me with formula. Many thanks

[Shruthi96]

@Jihwan_Kim , Thanks for responsding. Not sure why it is not working properly in project file. 

[Shruthi96 · Accepted solution]

Thanks @Jihwan_Kim , I applied filter for include. It worked

Scope CC =

IF (

    MAXX (

        FILTER ( Data, Data[Include] = "Yes" && Data[Product] = EARLIER ( Data[Product] ) ),

        Data[End Date]

    ) = Data[End Date],

    1,

    0

)

[Jihwan_Kim]

Hi,

Please check the below picture and the attached pbix file.

Scope CC =
IF (
    MAXX (
        FILTER ( Data, Data[Product] = EARLIER ( Data[Product] ) ),
        Data[End Date]
    ) = Data[End Date],
    1,
    0
)