Forum Discussion

ArsalanFND's avatar
ArsalanFND
Frequent Visitor
8 years ago

Running into Memory Issue

Hello People!   I will be brief and straight to the point.   i have a dataset as follows:   Date_Time                        Entry  Exit  (entry - Exit)  12/21/2016 12:00:00 AM    5       4   ...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI ArsalanFND,

 

Nope, it seems like your intervals split your records to too many sub-records which need to calculate and progress in memory.

 

I can only suggest you use 64 bit power bi desktop with large physical memory or prepare a detail table with detailed interval records to reduce calculate pressure.

 

In addition, you can also take a look at following link if your requirement is similar as below:

DAX - 15 minute Interval Question

 

Regards,

Xiaoxin Sheng

ArsalanFND's avatar
ArsalanFND
Frequent Visitor
8 years ago

Hi Xiaoxin,

 

Thanks for the reply, yes correct the sun-records are too many. 

 

The link you provide was helpful but i am ok with that part.

 

I am calculationg the Running Total based on my Date Time Table which as 3 years each day with 96 intervals. Which is a huge calculation every time. 

 

Is there a way i can calculate it and save it so it's not calculated every time?

 

Thanks,

FND