Not enough memory to complete this operation - column creation

[HxH]

Hi guys, 

this is a follow up to another topic when a user kindly provided a measure to calculate time not working in a table
This is the measure: 

Time not working =

var currentUser= 'TABLE'[UserID]

var currentdate = 'TABLE'[Date]

var currentlog = 'TABLE'[logs]

var currenttime = 'TABLE'[Datetime]

var nexttime = IF(currentlog=0,CALCULATE(MIN('TABLE'[Datetime]),ALL('TABLE'),'TABLE'[Datetime]>currenttime,'TABLE'[UserID]=currentUser,'TABLE'[Date]=currentdate,'TABLE'[logs]=1))

var timenotworking = DATEDIFF(currenttime,nexttime,MINUTE)

return

timenotworking

The table has 107k rows and 9 columns. It keeps telling me that there is not enough memory to perform the operation. The point is: i can create as much columns as I want in the table, this is the only one that won't work for memory problems. Could PBI be referring to another kind of problem with the wrong message error? Do you know what's happening? I tried looking at previous threads but in all the other situations the problem seems justified (there's people with millions of rows, other trying to load 57 tables and so on), my case is weird because I can create as much columns as I want beside this one so I can't figure it out. 

I've already done the standard stuff like disabling auto/date time and allow data preview to dowload in background

Thanks 

[Mariusz · Accepted solution]

Hi @HxH 

Replicate you calculation in Query Editor or check in Task Manager your memory behavior when you trying to calculate this column.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[HxH]

Memory in use goes up to 96-97% and then it gives me the error message. Looks like I will need to do some work in power query to improve the model or change the measure. Thanks 

[Mariusz]

Hi @HxH 

How much RAM do you have?

Best Regards,
Mariusz

Please feel free to connect with me.

[HxH]

8 GB 

[Mariusz]

Hi @HxH 

If you do a lot of work in power bi, you probably want to upgrade as that's where your model is being stored.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.