Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]
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
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"?