Compare Date difference for each ID

[Tommy23]

Hello I would like to have column where the difference (in days) is calculated between each End date for each ID is calculated.

Here a example of sample data ( this just an example , how to do it o it can work for various case)

ID	End date
1	01/02/2022
1	01/01/2022
2	18/01/2022
3	20/02/2022
4	19/01/2022
4	07/01/2022
4	03/03/2022
1	18/03/2022
2	07/01/2022
3	15/01/2022

Here a example of result I want to have

ID	nb DAYS	End Date
1	0	01/01/2022
1	31	01/02/2022
1	47	18/03/2022

Thanks :)

[binuacs · Accepted solution]

@Tommy23 are you looking something like below

[IraWatt · Accepted solution]

Hey @Tommy23,

You can use a multi row formula to achieve this:

Any questions or issues please ask :)
HTH!
Ira

[Tommy23]

Thanks It work @IraWatt @binuacs 

I also put another issues I had on this topic if you have also any idea I will be happy to ear it :)

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Time-between-period-for-each-ID/m-p/96...

[IraWatt]

No worries @Tommy23, I'm having a look at your question now 😃 Also if you find an answer to your question make sure to give it a green tick. 

[Tommy23]

Hello , Do you ave any Idea why I do not have the same result as you? is it because I am located in France and it is because of the time zone @IraWatt 

[IraWatt]

I'm not sure but it looks like the EndDate_Formatted was sorted descending when it should be sorted ascending?  Any ideas @binuacs ?

[binuacs]

@Tommy23 @IraWatt  I think sort tool has the problem based on the result given. @Tommy23 Can you share your output after the first sort tool