Calculated column not finishing processing due to memory limits

Hi there,

 

var versao_anterior = MAXX(FILTER(all(Incidents[Source.Name],Incidents[Number]),Incidents[Source.Name]<EARLIER(Incidents[Source.Name])&&Incidents[Number]=Earlier(Incidents[Number],Incidents[Source.Name])

 

So I basically have several excel files, with a daily version which I append over a big table - 5million rows ( I am in the process of cleaning the data).

With that said I use the first variable to determine which is the previous version for each incident - in order to get the previous incident state (in progress, closed, etc).

 

How would you approach this issue... I cannot calculate this way. Thanks!