Calculate recursive diff Dates of complain customers

[jppuam]

Hello,

i need to calculate the diff dates between the complains of certain customers.

For example in the image attached, for the first customer it has 4 complains (12 Mar, 3 Apr, 17 May and 20 May).

What i need to have, is on another column, the diff dates for the previews complain date.

The first would be 0, the second the diff of 3 Apr and 12 March, the 3rd, the diff of 17 May and 3 Apr...and so one...

for each customer ?

Can you help me ?

thansk

Joao Rodrigues

[amitchandak · Accepted solution]

@jppuam , Try a new column as

nueva columna ?
datediff( maxx(filter(Table, [client code] ?earlier([client code] ) && [complain date] <earlier([complain date])),[fecha de queja]),[fecha de queja],día)+0

[jppuam]

Thansk amitchandak, it was just that.

😊

[jppuam]

Hello,

in the post that i've made, i've forgot to refer also other column that i need, and if you could help.

Considering the control date the end of 2019 (31/12/2019), i need to know the difference of that date to the last date of each customer.

For example the first customer in my image is "1031". The last date é 20 May, so i need to calculate the difference from 31/12/2019 to 20/05/2019. Can you please help ?

Joao Rodrigues