Forum Discussion

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 ...

Frequent Visitor

8 years ago

Hi,

Also i able to create the measure with Running total. How can i calculate MAX for the day? for visuals.

Running total is measure and DateTime is a column from another table with realtionship.

Thansk,

Cheers,

Frequent Visitor

8 years ago

So I got the Max values. NOw my only issue is still i am unable to visualize MAX for the day. should i use SQL databse instead of Excel files to load and process m data faster??

Thanks,

Anonymous
Not applicable
8 years ago
HI ArsalanFND,

I'd like to suggest you create a table to store expand records, then you only need to do summarize on real records. In my opinion, it will spend less system resource than calculate with huge virtual table.

Regards,

Xiaoxin Sheng
- ArsalanFND
  Frequent Visitor
  8 years ago
  Hi,
  
  Yes thats what i am trying to do now, I have extract the table to get just the number of rows i want to het the running total of. So the max rows now i am dealing with are 37,678.
  I am using the following formula to creatre a new column to calculate the running total.
  
  Occupancy = CALCULATE(
  SUM('Table'[Occ]),
  ALL('Table'),
  'Table'[Index] <= EARLIER('Table'[Index])
  )
  
  But i am still facing not enough memory problem.
  
  ** It does calculate the running total if i reduce my number of rows. (which i can't no more)
  
  My machine has 16 gb of RAM, upgrading RAM would help me in this case? or there is something i am not doing efficently.
  
  Thanks,
  - Anonymous
    Not applicable
    8 years ago
    Hi ArsalanFND,
    
    Hmm, I guess you are using a 32 bit version of power bi right? If this is a case, you can download and use 64 bit version to allow power bi to use more memory resource.
    
    Regards,
    
    Xiaoxin Shengm