Memoy Error

[Anonymous]

Hello,

I am trying to calculate Average Open Ticket Age in Networkdays.  However, I am getting the error in my DAX formula of "There's not enough memory to complete this operation. Please try again later when there may be more mermory available."

The DAX formula I am using is:

AOTA = CALCULATE(SUM(Calendar[Workdays]),DATESBETWEEN('Calendar'[Date],IFS[EnteredDate],TODAY()))-1

I have approximately 2,000,000 rows of data.  Is there a way to solve this error message? Or find my calculation another way? 

Any help in solving this issue would be greatly appreciated!

[v-piga-msft]

Hi @Anonymous,

I think the following points may be causing this error:

Firstly,  you have 2 million rows of data so this performance will be poor.

In addition, theDATESBETWEEN function you used causes each of your rows to generate a virtual calendar to calculate the number of days from the current row to today, so it will take up a lot of memory.

Please filter your resource table, and just load the necessary data. There are some tips about managing Memory, you can review them in this similar thread.

Alternatively, you can use Filter(table name, condition) function to replace DATESBETWEEN function when you calculate the workdays, that the performance may be better.

Best Regards,

Cherry