Forum Discussion

ArsalanFND's avatar
ArsalanFND
Frequent Visitor
7 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
7 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
7 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,

  • ArsalanFND's avatar
    ArsalanFND
    Frequent Visitor
    7 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's avatar
      Anonymous
      Not applicable
      7 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's avatar
        ArsalanFND
        Frequent Visitor
        7 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,