Not enough Memory Error over a New Column

[uif19085]

Hello, i'm trying to create a column to get the first day when a status is changing and flag it with TRUE, i've tried it
with less data and it works fine but when using over big data it gets me an memeory error, i only have 16GB RAM, what i'm thinking is to find a way to make this formula optimized or maybe if someone can helo me with some other solution. Thank you

Is First Day in State =

ISBLANK (CALCULATE (

    COUNTROWS ( FCA_Test ),

        ALLEXCEPT ( FCA_Test, FCA_Test[id] ),

        FCA_Test[updated] < EARLIER ( FCA_Test[updated] ),

        FCA_Test[status] = EARLIER ( FCA_Test[status] )

))

[amitchandak]

@uif19085 , Try to create rank first list this

Rankx(filter(FCA_Test, FCA_Test[id] = earlier(FCA_Test[id]) && FCA_Test[status] = EARLIER ( FCA_Test[status] )),FCA_Test[updated], ,asc,dense)

if needed use another column

or rank =1 can be used as filter