Finding repeat clients within 30 days

[edcdcpowerbi]

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.

[daXtreme]

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"?

[Anonymous]

Hi @edcdcpowerbi,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? They will help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng