Average Customer Return Time

[Milan_TBC]

Hi,

I want to calculate the average return time of my customers over time. 
I have a table with general data such as Cust_ID, and order_date per order. 
Right now i have general calculations based on first_order and last_order, however this doesn't cover all averages, since some customers have 10+ orders. 

Is there a way to calculate the average time between orders? Using the regular DATE commands (DATEDIFF, DATESBETWEEN, etc,), i run into problems since most of them only accept two dates, not more. 

Thanks in advance!

[amitchandak · Accepted solution]

@Milan_TBC , A new column

Diff =

var _max  = maxx(filter(Table, [Customer] = earlier([Customer]) && [Order date] < earlier({order date]) ) , [Order Date])

return

datediff(_max, [Order date], day)

Then you can take AVg of this column

Or move this in a Meausure

AverageX(Table,

var _max  = maxx(filter(Table, [Customer] = earlier([Customer]) && [Order date] < earlier({order date]) ) , [Order Date])

return

datediff(_max, [Order date], day) )

Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8