Get Datediff by group

Hi, AlexGlz 

If I didn't misunderstand your meaning ,you can try the following steps:

1. Sort the table by “id” and “ date”
2. Insert a index column into the table to help you create DAX.( You can right-click to hide the created index column if you don't need to display it )
3. Create calculate columns “Next Date01” and “Datediff” like that :

Next Date01 = 
var ind='Date'[Index]+1
var nextdate=CALCULATE(MAX('Date'[Date]),FILTER('Date','Date'[Index]=ind))
var nextid=CALCULATE(MAX('Date'[id]),FILTER('Date','Date'[Index]=ind))
var val=IF('Date'[id]=nextid,nextdate,TODAY())
return 
val
​

DateDiff = 
var days=DATEDIFF('Date'[Date],'Date'[Next Date01],DAY)
RETURN days
​

Here’s a sample I made:

url:https://wicren-my.sharepoint.com/:u:/g/personal/michael_wicren_onmicrosoft_com/ETgEEy8xRn5IiQrnvkI__3UBqPFpMsyG6OmkGxjl5XUKRA?e=DKkaQn 

Best Regards,

Eason

Community Support Team _ Eason Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.