Calculated column to result True or False depending on last time customer engaged

[MadalenaBicho]

Hello all,

My query is related to this previous post: 

Solved: Calculated column that tells me whether someone ha... - Microsoft Fabric Community

My organisation also looks at 'Returning clients', which are existing clients that have re-engaged with us after 6 months or more of no contact. 

How could I modify the DAX formula provided in the solution in the above post to return True for anyone who is a 'Returning Client'? 

Many thanks in advance! 

[BIstvan · Accepted solution]

@MadalenaBicho  you can try the below.

ReturningClient = 

IF(

    CALCULATE(

        COUNTROWS('YourTableName'),

        FILTER(

            'YourTableName',

            'YourTableName'[ClientID] = EARLIER('YourTableName'[ClientID])

        )

    ) > 0,

    "True",

    "False"

)