Forum Discussion
Javicesp
2 years agoNew Member
Consumer Repeat Rate
Hello everyone,
I would like to know if a person called back so I can count the days between the first and the second contact.
Currently my data is extracted like this:
| Consumer ID | Contact Date |
| 1002 | 12-Aug |
| 1003 | 6-Oct |
| 1002 | 13-Aug |
| 1004 | 7-Oct |
| 1005 | 9-Sep |
| 1005 | 7-May |
And I'd like to know what DAX formula could be used to filter everything like this.
| Consumer ID | 1st contact | 2nd contact |
| 1002 | 12-Aug | 13-Aug |
| 1005 | 9-Sep | 7-May |
and rule out the people who has only one contact.
Thank you so much for your help.
Hi,
PBI file attached.
Hope this helps.
2 Replies
- ThxAlotSuper User
- Ashish_MathurSuper User