Forum Discussion

Javicesp's avatar
Javicesp
New Member
2 years ago
Solved

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 IDContact Date
100212-Aug
10036-Oct
100213-Aug
10047-Oct
10059-Sep
10057-May

 

And I'd like to know what DAX formula could be used to filter everything like this.

 

Consumer ID1st contact2nd contact
100212-Aug13-Aug
10059-Sep7-May

 

and rule out the people who has only one contact.

 

Thank you so much for your help.