Forum Discussion

edcdcpowerbi's avatar
edcdcpowerbi
Icon for Helper I rankHelper I
4 years ago

Finding repeat clients within 30 days

I need to be able to find repeat clients who have used our service within 30 days of their first acitivty closing. I can get a total of the repeats, but quite clueless on how to find repeat clients within 30 days. 

 

Columns I have:

Client[ClientID] 

Activity[Acitivtyopendate]

Activity[Activityclodedate] 

'Activity'[ActivityID]

 

Total Activity # = DISTINCTCOUNT( 'Activity'[ActivityID] ) + 0
 
Referred Clients # = DISTINCTCOUNT ( 'Referral'[ClientID] ) + 0
 
Repeat Activity # = [Total Activity#] - [Referred Clients #]
 
This gives me the number of repeat clients. i.e. A client with more than one activityID.
But I dont know what to do from here. Sorry I cant provide any more measure, i am very new to DAX.
 

2 Replies

  • daXtreme's avatar
    daXtreme
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi there.

    I can't help you because the description of the problem is a bit vague. Would you mind explaining this in some more detail, please? What does it mean, for instance, that you want to "find repeat clients within 30 days"?