topic Calculated column to result True or False depending on last time customer engaged in DAX Commands and Tips

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

MadalenaBicho — Thu, 15 Aug 2024 15:46:46 GMT

Hello all,

My query is related to this previous post:

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 — Thu, 15 Aug 2024 15:57:16 GMT

MadalenaBicho you can try the below.

ReturningClient =

IF(

CALCULATE(

COUNTROWS('YourTableName'),

FILTER(

'YourTableName',

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

)

) > 0,

"True",

"False"

)