Average days between orders

Question

Question is simple, but I'm totally lost.I have the next data:buyerID - OrderId - Rank (1,2,3...meant order index)&nbsp; - Purchase date&nbsp;123&nbsp; &nbsp; &nbsp; &nbsp;- 123347&nbsp; &nbsp; &nbsp; - 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;- 1/1/2019123&nbsp; &nbsp; &nbsp; &nbsp;- 123354&nbsp; &nbsp; &nbsp; - 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;- 1/3/2019143&nbsp; &nbsp; &nbsp; &nbsp;- 145347&nbsp; &nbsp; &nbsp; - 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;- 1/2/2019145&nbsp; &nbsp; &nbsp; &nbsp;- 168437&nbsp; &nbsp; &nbsp; - 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;- 1/1/2019&nbsp;I need to calculate AVG numbers of days between orders using measureThanks!

vanessafvg · Accepted Answer

juli__sia123412&nbsp;
&nbsp;
you would first need to create a calculated column that gets the difference in days between orders
&nbsp;

DateDiff Previous TransactiondDate = 
DATEDIFF(
 CALCULATE(
 max(Table2[Purchase date])
 ,FILTER(
 ALL('Table2')
 ,Table2[buyerID] = EARLIER(Table2[buyerID]) &amp;&amp; 'Table2'[Purchase date] &lt; EARLIER(Table2[Purchase date]) )), Table2[Purchase date], day)
&nbsp;
then you can do an avg on that difference with a calculated measure
&nbsp;

avg = CALCULATE(AVERAGE(Table2[DateDiff Previous TransactiondDate]))

&nbsp;
&nbsp;

Forum Discussion

Average days between orders

2 Replies

Related content

Average and Moving Average

Calculate Average Order frequency

Accumulated average

Weekly Average

measure average age per order