Calculated column not finishing processing due to memory limits

[campelliann]

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!

Source.name	Incident Number	Incident Stat
14-01-2023	1	progress
19-01-2023	5	closed
21-02-2023	1	closed

[amitchandak · Accepted solution]

@campelliann , Create two measures like

Rank = rankx(filter(Incidents, Incidents[Number]=Earlier(Incidents[Number])),Incidents[Source.Name])

Previous Status = Maxx(filter( Incidents, Incidents[Number]=Earlier(Incidents[Number]), [Rank] = earlier([Rank]) -1), [Status])

[campelliann]

Yep exactly what I did 🙂