Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |