Number of days between two dates

[Anonymous]

Hello,

I have a table by customer and date of order and I would like to know for each client the time between his first order and his second, the second and the third and the third and more Could you help me? I tried to use the interval function but the result is not good

the result must be the following and an example is attached

Thank you for your help

[trdandamudi]

May be as below:

[Anonymous]

thanks  not exactly because I need only synthesis for each step as in the following example for switching to a command to the second

[Anonymous · Accepted solution]

Hello,

finally, I found my answer using the interval function and the minimum

= sum(aggr(Interval(  min(  [Date Commande],2)-min(   [date],1),'D'),[Customer]))/count(distinct([Customer])