Calculate the day difference of the next out date for 8 million rows of data, out-of-memory error

[Pandadev]

Hi I'm trying to calculate based on the identification code and the date of departure, the length of time between the next previous departure date, so I can filter only those that are greater than or equal to 7 days.

I've tried these formulas, but I only get an out-of-memory error. Is there a more efficient way to do this please.

PreviousDateCalculation á CALCULATE(max('TU Feed'[departure]),FILTER('TU Feed','TU Feed'[ID]'EARLIER('TU Feed'[ID])&&'TU Feed'[departure]<EARLIER('TU Feed'[departure])))
DateDiffCalculation á DATEDIFF('TU Feed'[PreviousDateCalculation],'TU Feed'[departure],DAY)

[V-pazhen-msft · Accepted solution]

@Pandadev 

Check the currently used memory and try increase the max cache size accordingly.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.