fFInd Difference Between Current and previous ticket

Hi Team,

I have report where I need to calculate the difference between close date of same ticket number and its previous  ticket number who’s type is visit. I have 22600000 record in my Table. I have use earlier function but doesn't working with large number of data.
Here is sample Data.
For e.g. My SQL look like this
Select DateDiff(Day,CurrentCloseDate,PreviousCloseDate) where Type=Visit

My Result will look like

Please Don't suggest to use Earlier function, it’s doesn't work with large number of record. If I use Earlier function, when press enter after creating measure it always shows processing. I also use below measure and when I hit enter it always show's processing and to close power bi need to use task manager.

I have use Below Measures but doesn't work

Diff=var CurrentCloseDate var= CurrentTicketNumer var previousTicketCloseDate= calculate(Min(CloseDate),topn(1,CaseTable,CloseDate<CurrentCloseDate && CurrentTicketNumer=TicketNumber,asc)
return DateDiff(CurrentCloseDate var,previousTicketCloseDate,Day) ---Doesn't--

---Also Used----
Diff=var CurrentCloseDate var= CurrentTicketNumer var previousTicketCloseDate= calculate(Min(CloseDate),Filter(All(CaseTable),CloseDate<CurrentCloseDate && CurrentTicketNumer=TicketNumber)
n return DateDiff(CurrentCloseDate var,previousTicketCloseDate,Day)

I have been stuggling way to long to find the solution of the problem, I have found the blog

"https://exceleratorbi.com.au/use-power-query-compare-database-records/#comment-29853-Current%20vs%20Previous "

to the similar solution but it will only give difference bewteen current row and previous row but requirement is to calculate difference bewteen current row and it previous row who's type is visit

Below measure I have used for the problem

Diff=var CurrentCloseDate var= CurrentTicketNumer var previousTicketCloseDate= calculate(Min(CloseDate),topn(1,CaseTable,CloseDate<CurrentCloseDate && CurrentTicketNumer=TicketNumber && type="Visit",asc)
return DateDiff(CurrentCloseDate var,previousTicketCloseDate,Day) ---Doesn't--

---Also Used----
Diff=var CurrentCloseDate var= CurrentTicketNumer var previousTicketCloseDate= calculate(Min(CloseDate),Filter(All(CaseTable),CloseDate<CurrentCloseDate && CurrentTicketNumer=TicketNumber && Type="Visit")
n return DateDiff(CurrentCloseDate var,previousTicketCloseDate,Day)

jitendra89doon,

You may take a look at the post below and try using Table.Group.

https://community.powerbi.com/t5/Desktop/Custom-column-Index-or-Ranking-by-other-column/td-p/33864

I see no reason why the principle I have demonstrated in my video wont work for you.  You simply have to apply a filter on type is visit before executing the rest of the pattern I have demonstrated using Power Query.  Did you try that?