Forum Discussion
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...
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)