Calculate time between values

[Anonymous]

Hi all, 

I need to create a columnt that indicates how many days have passed between last two activities with the same client. Here's an example: 

ID	Date (mm/dd/yyyy)	Days between activities
321546	1/5/2019	null
456878	1/7/2019	null
321546	1/9/2019	4
456878	1/30/2019	23

So with the information in columns [ID] and [Date], I'd like to create the column [Days between activities]. In the above example the first two rows of table values would be first activities from new clients, thus the values in [Days between activities] being null (because there are no earlier activities). 

Any help would be greatly appreciated! 

[amitchandak · Accepted solution]

Try like

datediff(table[date],MINX(filter(Table,Table[Date]>EARLIER(Table[Date]) 
&& Table[Id]= EARLIER(Table[Id])),Table[Date]),DAY)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

Dear @amitchandak , 

thank you so very much for your assistance. You are a true Power BI hero and wizard! It worked on the first try, simple and efficient. I salute you! 

Kind regards, 

Heidi