Forum Discussion
Memoy Error
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 aga...
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